Have Duration include an option for timecode

[prodman]

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

...

[stevendasilva]

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

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)

    )

)

Steven Da Silva

Systems With Steve