Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! 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
455 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.