![Cody_Winchester Cody_Winchester](https://community.airtable.com/legacyfs/online/avatars/3X/4/4/44ba848247415d983cb83db970352fa57a77d857.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 18, 2024 11:48 AM
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!
Solved! Go to Solution.
Accepted Solutions
![Cody_Winchester Cody_Winchester](https://community.airtable.com/legacyfs/online/avatars/3X/4/4/44ba848247415d983cb83db970352fa57a77d857.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 18, 2024 01:45 PM
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).
![Cody_Winchester Cody_Winchester](https://community.airtable.com/legacyfs/online/avatars/3X/4/4/44ba848247415d983cb83db970352fa57a77d857.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 18, 2024 01:45 PM
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).
![](/skins/images/75AB00B4920FD2D67A8CABF77C9DECC4/responsive_peak/images/icon_anonymous_message.png)