Function for hrs:mins:secs:frames for timecode calculations

[Richard C. Ferryman]

I want to set up a spreadsheet that adds or subtracts timecodes for
video work. Timecodes are in the format HH:MM:SS:FF
where hours are 00-99
mins are 00-59
secs are 00-59
frames are 00-24 or 00-29 dependent on system (European PAL25 frames
or American NTSC 30 frames for example).
So I need to take a string such as 05:13:20:03 and be able to subtract
or add another string such as 00:05:33:19 and end up with a correctly
formatted result with carries between columns at the correct 99/00,
59/00, 59/00, 24/00 points.
Any suggestions as to how to approach this?
Thanks
Richard

 

[Frank Kabel]

Hi
there are some Add-ins which could achieve this. Have a look at:
http://www.belle-nuit.com/timecode/
http://j-walk.com/ss/pup/pup5/functions.htm


and have a look at the following Google results:
http://groups.google.com/groups?as_q=timecode&as_ugroup=microsoft.publi
c.excel.*&num=100&as_scoring=d&hl=en