• Adobe Premiere Pro

  Time Code Formula

  Posted by John Baumchen on September 30, 2005 at 6:21 pm

  I’m wanting to develop an edit sheet in Excel and would like to know if anyone has developed a formula to calculate drop frame and non-drop frame information.

  I’d be willing to share the template to anyone who wants.

  Cheers.

  John Baumchen replied 20 years, 7 months ago 3 Members · 3 Replies
• 3 Replies

• 

  Lkj

  September 30, 2005 at 7:12 pm

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

  Aanarav Sareen

  September 30, 2005 at 9:53 pm

  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

  September 30, 2005 at 11:18 pm

  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.

Reply to this Discussion! Login or Sign Up