Help

Create duration from 3 integers

Solved
Jump to Solution
597 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Fabian
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a form where users can post their time-based results. To make sure data is valid I use 3 fields in the form representing hours, minutes and seconds.

So I end up with 3 integers in my table. How to I make a DURATION format (h:mm:ss) out of these fields?

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

You can use a formula field that calculates the total number of seconds, then set the formatting for the formula field to duration.

({hours} * 3600) + ({minutes} * 60) + {seconds}

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

You can use a formula field that calculates the total number of seconds, then set the formatting for the formula field to duration.

({hours} * 3600) + ({minutes} * 60) + {seconds}
Fabian
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks @kuovonne! I had it right myself but had the fields as strings, not integers and that didn’t work.