Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Converting hours:minutes:seconds to total minutes

Solved
Jump to Solution
2992 0
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!