Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Have Duration include an option for timecode

cancel
Showing results for 
Search instead for 
Did you mean: 
prodman
4 - Data Explorer
4 - Data Explorer
Status: New Ideas
What is the proposed idea/solution?

For film production, we need the ability to sum durations that are 24 frames per second. 

HOURS:MINUTES:SECONDS:FRAMES

With the current 00:00:00 format, it does not calculate accurately. 

 

...

How does is solve the user problems?

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. 

...

How was this validated?

Currently there's no way to tell AT that after 24 frames it's a new second.

...

Who is the target audience?

film production and editorial users

 

...

1 Comment
stevendasilva
6 - Interface Innovator
6 - Interface Innovator

Hello @prodman 

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: 

https://www.loom.com/share/584c520fbf2b4e89bf16123ec03b1c17?sid=f0166573-a956-4c84-877e-051b5a07ef7e

stevendasilva_1-1699039008337.png

stevendasilva_0-1699037612926.png

Formula to convert video length into duration text field 
 
IF({Video Length (s)}>3600,
CONCATENATE(
    INT({Video Length (s)}/3600),
    IF(INT(MOD({Video Length (s)},3600)/60)<10,":0",":"),
    INT(MOD({Video Length (s)},3600)/60),
    IF( MOD(({Video Length (s)}),60)<10,":0",":"),
    MOD(({Video Length (s)}),60) ),
CONCATENATE(
    INT(MOD({Video Length (s)},3600)/60),
    IF(MOD(({Video Length (s)}),60)<10,":0",":"),
    MOD(({Video Length (s)}),60)
    )
)
stevendasilva_2-1699039324404.png
stevendasilva_4-1699039349382.png

Steven Da Silva

Systems With Steve