Duration Field for Timecode?

[Scott_Ratner]

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

[Justin_Barrett · Accepted solution]

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:

[Scott_Ratner]

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.

[Justin_Barrett]

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]

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).