Posted by Hugh Taylor on October 09, 2001 3:06 PM
I need help building an Excel spreadsheet that would list a number of TV spots, their lengths, and calculate a running timecode based on the spots and their lengths. I work in drop frame timecode which basically drops a frame (30 frames per second) every minute, except every 10th minute. In addition, there will be 9 seconds of space between each spot (for black and slate)
the finished spreadsheet would look like this:
and would calculate the "Start Time" as new spots were added to the list...
Description Length Start Time
spot 1 :20 1:00:00:00
spot 2 :30 1:00:29:00
spot 3 :20 1:01:08:02
spot 4 :10 1:01:37:02
Timecode is Hours:Minutes:Seconds:Frames
Thank you for any help!!!!!!!!!