Given a drop frame timecode, in hh:mm:ss:ff , what is the formula to convert it to non drop frame timecode?
Conversely, given a non drop frame timecode, what is the formula to convert it to drop frame timecode?
I know the explanation, i.e., drop 2 frames every minute except 0, 10, 20, etc.
But I can't turn it into straightforward formulas.
And by straightforward formula I mean somehing that I can program in an Excel spreadsheet.
Or, is there an Excel spreadsheet that already does these conversions?
P.S. There may be other programs that will do these conversions, but for my purpose it's got to be an Excel spreadsheet.
Try StreamFab Downloader and download from Netflix, Amazon, Youtube! Or Try DVDFab and copy Blu-rays!
+ Reply to Thread
Results 1 to 2 of 2
Thread
-
-
Hi-
I don't know anything about Excel or if this helps at all or not, but to go from 30fps to 29.97fps you divide by 1.001.
30000/1001=29.970030
Similar Threads
-
jvc gy-hm 700 drop frame
By seistro in forum Camcorders (DV/HDV/AVCHD/HD)Replies: 3Last Post: 23rd Sep 2012, 12:31 -
How can I walk by frame and get timecode for a mkv file?
By nzdreamer55 in forum EditingReplies: 1Last Post: 20th Dec 2010, 10:14 -
HDV Video >>>>> Use Non drop frame or drop frame and why?
By Canon GL-2 Guy in forum Newbie / General discussionsReplies: 7Last Post: 3rd Nov 2010, 18:30 -
Play an MTS file frame by frame, displaying timecode or frame number
By SeánB in forum Software PlayingReplies: 5Last Post: 5th Oct 2010, 16:26 -
Frame drop in firewire HDV transfer
By Dinu Bandyopadhyay in forum Camcorders (DV/HDV/AVCHD/HD)Replies: 17Last Post: 19th Oct 2007, 11:29