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
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…


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