Skip to main content
Question

Adding placeholder zero values to Duration field type?

  • April 14, 2026
  • 2 replies
  • 21 views
M
Forum|alt.badge.img

I’m working with video timecodes using the DURATION field type, and am entering data in an HH.MM.SS.mmm format (H=hours, M=minutes, S=seconds, m=milliseconds). I need the data to reflect the values in the hours and minutes places even if those are zero.

 

Right now, if I type in the data for one minute, three seconds, and 124 milliseconds, that data shows as 01:03:124 , but I need it to display as 00:01:03:124

Similarly, if I type in the data as 15 seconds, 654 milliseconds, it shows as 15.654 , but I need it to display as 00:00:15.654

 

Anyone have a formula or workaround that will facilitate this?

2 replies

TheTimeSavingCo
Forum|alt.badge.img+32

Does this look right?

RIGHT("00" & INT({Duration} / 3600), 2) & ":" &
RIGHT("00" & INT(MOD({Duration}, 3600) / 60), 2) & ":" &
RIGHT("00" & INT(MOD({Duration}, 60)), 2) & "." &
RIGHT("000" & ROUND(MOD({Duration}, 1) * 1000), 3)

 

Adam, Airtable Consultant - thetimesaving.company
M
Forum|alt.badge.img
  • mattmiller88
  • Author
  • New Participant
  • April 15, 2026

That worked! Thanks ​@TheTimeSavingCo!

    Terms & ConditionsAccessibility statement