Help

Re: Duration Field for Timecode?

Solved
Jump to Solution
705 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Ratner
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi, I am looking for a way to input Timecode in a Field, (ie: 12:24:32:00) (HH:MM:SS:FRAMES) The Duration type comes close but no option for double digit hours, and regular numbers don’t seem to allow colons.

Anyone have any ides.

Scott

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

I’d probably use a text field, which has no restrictions. Are you looking to do any calculations on the times you enter? That may become tricky if so.

EDIT: BTW, welcome to the Airtable community! :grinning_face_with_big_eyes:

See Solution in Thread

4 Replies 4
Justin_Barrett
18 - Pluto
18 - Pluto

I’d probably use a text field, which has no restrictions. Are you looking to do any calculations on the times you enter? That may become tricky if so.

EDIT: BTW, welcome to the Airtable community! :grinning_face_with_big_eyes:

Ughh… Should have thought of that. Thanks! But it would be nice to have support for time code, so we could have it do calculations in cells for adding up segments for a TV show Im on.

Agreed. I suggest posting to the Product Suggestions category with this request. I don’t think it would be that difficult to expand the Duration type to allow more detail on both ends (double-digit hours on the high side, frames on the low side)

Nimrod_Erez
5 - Automation Enthusiast
5 - Automation Enthusiast

Just for clarity, timecode support means that a cell can be edited to support timecode in a specified frame rate (23.976, 24, 29.97, 30, etc.) so any duration and calculations on timecode yield proper results. A timecode cell needs to be in a HH:MM:SS:FF format under a frame rate system (as noted above).