Hi there,

I’m trying to work with video timecode and the DURATION field type doesn’t cut the mustard, as I need HH:MM:SS:FF (frames) formatting.

See another post on this at Video Timecode Field

I’ve found a great pair of Excel formulas to convert FRAMES into HH:MM:SS:FF and back, but I would really appreciated help turning this from EXCEL into AIRTABLE syntax please, where cell A1 could be another text field…

=VALUE(LEFT(A1,2))6060*30+VALUE(MID(A1,4,2))6030+VALUE(MID(A1,7,2))*30+RIGHT(A1,2)

Example:

A1: 01:06:46;11

RESULT: 120191

=TEXT(MOD(INT(INT(INT(ABS(A2)/30)/60)/60),60),“00”)&":"&TEXT(MOD(INT(INT(ABS(A2)/30)/60),60),“00”)&":"&TEXT(MOD(INT(ABS(A2)/30),60),“00”)&";"&TEXT(MOD(ABS(A2),30),“00”)

Example:

A2: 112019

RESULT: 01:02:13;29

Thanks in advance!!

(The formula above came a very helpful post at https://github.com/cgranier/Excel-Timecode )