Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Video timecode - Excel formula translation to Airtable syntax

Topic Labels: Formulas
1269 0
cancel
Showing results for 
Search instead for 
Did you mean: 
EastEndTom
6 - Interface Innovator
6 - Interface Innovator

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