Create duration from 3 integers

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?

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}
2 Likes

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

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.