So there are some really smart people on here. I'm wondering if anyone has a good solution here.

Shot a television show 1080i 24p. It looks great. 24 frames per second, just like film. However, the network wanted it delivered on a HDCAM tape at standard NTSC 60i which 59.94 Hrz also known as 29.97 frames per second. So I went and converted the entire thing over. Delivered it, they were happy, yay.

Now the bad news ... attached to my tape was a shot-by-shot list. Each shot I have the time code (see below) and a description. This code is based on 24 frames taking 1 second, not 29.97 frames taking 1 second. After the 25th frame the timecode sheet is pretty much worthless.

Time Code is formatted much like real time, with an extra set of numbers. So for the tape it would start at 01:00:00:01 with 01 being the hour, the second set of numbers being the minutes, the third set being seconds, and the final set being frames. After 24 (or 29.97) frames the second advances

The conversion factor would be multiplying the frame rates times 1.24875, but in Excel I can't really do 1:03:59:04 x 1.24875 and get any useful number.

Does anyone have any ideas without me having some poor bastard intern to re-watch the program and convert it all by hand?

Well crap, I'm really dumb. You can ignore this - the solution is too easy, I don't know why I didn't think of it hours ago.

Happens to me all the time Kelraz,

I will be stumped on a programming hang up for an hour or two and will finally break down and seek help from a co-worker.

Half way through explaining the problem to the co-worker a light bulb goes off in my head and I have solved the problem.

Sometimes you just need to get out of the chair, take a walk and bam, the solution presents itself.

Cheers,

Well the thing is if you take a 60 minute program at 24 frames per second and convert it to 29.97 frames per second .... its still a 60 minute program. It doesn't get longer just by adding frames, else your 60 minutes of soundtrack would be totally out of sync. Silly me.

Well the thing is if you take a 60 minute program at 24 frames per second and convert it to 29.97 frames per second .... its still a 60 minute program. It doesn't get longer just by adding frames, else your 60 minutes of soundtrack would be totally out of sync. Silly me.


Thats what was going through my head as I was reading your description of the problem, but I figured I must be missing something, heh.