Create duration from 3 integers

[Fabian]

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?

[kuovonne · Accepted solution]

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]

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