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.

Convert String Representing Duration to Duration Type

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

I've been scouring this forum for an answer to a variant of "Convert String to Duration" but alas, no simple answers uncovered!

  • In my case, I have a text field that contains duration as as string such as, "1:30:00."
  • I need this to now be a field that is either a number (1.5), or an actual Duration type field.
  • DATEADD(), DATETIME_PARSE(), DATETIME_FORMAT(), etc. formulas return errors and cannot format this particular representation of time as a string.

What incantation of formula language is required for Airtable to do this so I can use this data? Thanks!

1 Solution

Accepted Solutions
Cody_Winchester
6 - Interface Innovator
6 - Interface Innovator

I managed to decipher a solution within this post. It came down to using the VALUE() function and dividing by desired unit of time (/3600 to yield hours).

See Solution in Thread

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

I managed to decipher a solution within this post. It came down to using the VALUE() function and dividing by desired unit of time (/3600 to yield hours).