Video timecode - Excel formula translation to Airtable syntax

Topic Labels: Formulas
889 0
Showing results for 
Search instead for 
Did you mean: 
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…


A1: 01:06:46;11
RESULT: 120191


A2: 112019
RESULT: 01:02:13;29

Thanks in advance!!

(The formula above came a very helpful post at )

0 Replies 0