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?
Best answer by kuovonne
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}
+29Welcome 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}
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}
Thanks @kuovonne! I had it right myself but had the fields as strings, not integers and that didn’t work.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.