Time Code Formula

[Lkj]

I think I saw something like this on Ken Stone’s site (FCP).

[Aanarav Sareen]

Is this what you are looking for?
https://www.mediachance.com/dvdlab/freetime.htm

Aanarav Sareen
Adobe Certfied Expert, Premiere Pro
https://www.asvideoproductions.com/video

[John Baumchen]

Hi Aanarav,

I found the formula that I’ll try out. it is:
=IF((FramesEnd-(FramesStart-1))<0,TimeEnd-TimeStart-TIME(0,0,1),TimeEnd-TimeStart)

Where Frames is a colum next to TimeStart and TimeEnd.
TimeStart and TimeEnd are time type fields.

An example:

Start______________End__________Duration
0:00:12:04______0:02:20:29______0:02:08:26

To use in Excel, here is the formula as used for the H:M:S of the Duration in row 6:
=IF((F6-(D6-1))<0,E6-C6-TIME(0,0,1),E6-C6)

The Start information is actually two colums, 'C' & 'D'. Colum 'C'is a time type cell and is 0:00:12 in the first row of the example above. Colum 'D' is the frames and is 04.

The End information is set out the same as the Start colums and is referenced by Colum E.

The formula for the frames cell in the Duration information is:
=IF((F6-(D6-1))<0,F6-(D6-1)+$D$1,F6-(D6-1))

Cheers.