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.

Converting hours:minutes:seconds to total minutes

Topic Labels: Formulas
Solved
Jump to Solution
3791 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Bobby_Lahiere
4 - Data Explorer
4 - Data Explorer

Is there any way to convert hh:mm:ss to total number of minutes like you can in Excel (Excel: Convert hours and minutes to minutes | CyberText Newsletter)?

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Is your hh:mm:ss in a duration field or a text field?

If it is a duration field, divide the duration field by 60. Under the hood, duration fields are stored as a number of seconds.

If the original value is a text field, you will need to parse out the parts, convert them to numbers, and then do the math.

See Solution in Thread

3 Replies 3
Steve_Wyrostok
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Bobby!

I think it’d help to first know what your data starting point is. Are you starting from a duration field? Or are you calculating the difference between two date/times and then needing to convert that duration of time into pure minutes?

For example in the screenshot below I am doing the latter in one formula, first calculating the difference in date/time across two fields, then having it display in minutes.

Whether you’re calculating it off two fields or converting one, the answers ought to be in this set of articles: https://support.airtable.com/hc/en-us/sections/1500000081022-Working-with-dates

Hope this helps! Good luck!

Screen Shot 2022-04-11 at 12.37.17 AM

kuovonne
18 - Pluto
18 - Pluto

Is your hh:mm:ss in a duration field or a text field?

If it is a duration field, divide the duration field by 60. Under the hood, duration fields are stored as a number of seconds.

If the original value is a text field, you will need to parse out the parts, convert them to numbers, and then do the math.

Bobby_Lahiere
4 - Data Explorer
4 - Data Explorer

Thank you! The suggestion from @kuovonne worked!