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 )
