Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Video timecode - Excel formula translation to Airtable syntax

Topic Labels: Formulas
610 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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 )

0 Replies 0