One way to do this is to split the column by delimiter (colon in this case) to get separate columns for days hours minutes and seconds
and then add a custom column using this formula
[Text.1] + ([Text.2]/24) + ([Text.3]/1440) + ([Text.4]/86400)
One way to do this is to split the column by delimiter (colon in this case) to get separate columns for days hours minutes and seconds
and then add a custom column using this formula
[Text.1] + ([Text.2]/24) + ([Text.3]/1440) + ([Text.4]/86400)