Skip to main content
Solved

Convert String Representing Duration to Duration Type

  • November 18, 2024
  • 1 reply
  • 0 views

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!

Best answer by Cody_Winchester

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).

View original
Did this topic help you find an answer to your question?

1 reply

  • Author
  • Inspiring
  • 25 replies
  • Answer
  • November 18, 2024

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).


Reply