Duration Field not displaying zero values

[chiara]

Hello, 

I'm using the duration field to track recorded audio sessions that vary in length. Currently have it formatted as (HH:MM:SS) to account for sessions that are both multiple hours long and less than an hour long. When I have sessions that are less than an hour long, Airtable won't display a zero value in the hour slot. Ex: a session is 30 minutes and 6 seconds, but Airtable displays it as 30:06. This makes it appear as if the session is 30 hours and 6 minutes long. I would prefer it to display as 00:30:06 for clarity. Does anyone know how I can get the field to display zero values? 

[TheTimeSavingCo]

Hmm, I don't think that's an option I'm afraid.  What if we made a formula field to output it with the leading zero?

[chiara]

That would be great! Do you have a formula that could accomplish this?

[TheTimeSavingCo · Accepted solution]

Yeap, I've set it up here!  Once you duplicate the base to your workspace you'll be able to view the formulas.  Was debating whether to paste the formulas here but it makes more sense for you to view it all as a whole I reckon

[chiara]

This is such a huge help, thanks so much!