Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

How to begin converting Time String to Number or Duration

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
453 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Cody_Winchester
6 - Interface Innovator
6 - Interface Innovator

I have a weird one: How would I even begin to convert a column that contains duration data formatted as a string like this? I want the final conversion to be a decimal number, but none of the standard DATETIME() type formulas can make sense of it. Help!

1 Solution

Accepted Solutions
Cody_Winchester
6 - Interface Innovator
6 - Interface Innovator

I arrived at part of the solution by following the solution in this thread.

See Solution in Thread

1 Reply 1
Cody_Winchester
6 - Interface Innovator
6 - Interface Innovator

I arrived at part of the solution by following the solution in this thread.