This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
For film production, we need the ability to sum durations that are 24 frames per second.
With the current 00:00:00 format, it does not calculate accurately.
With the current duration formatting we can come close, but not be exact when summing TRT from multiple fields. A timecode format would allow accurate calculations.
Currently there's no way to tell AT that after 24 frames it's a new second.
film production and editorial users
I think the closest we can get right now is to use the format h:mm:ss.sss for the duration (this is the largest amount of decimal places Airtable can hold for a duration)
Then multiply by 24 to get the number of frames.
You could then construct a cell that contains both the duration and the frames. In order to combine them, you will need to use a formula to convert the duration to a text format.
Please see this video here:
Steven Da Silva
Systems With Steve