Video Timecode?

[Anon]

Hi:

I am wanting to create a spreadsheet to log video timecode(t/c). The
format needs to be like this:

hh:mm:ss:??
hh=hour mm=minutes ss=seconds ??=frames(i'm not sure what this
would be)

I want to be able to subtract the start t/c from the stop t/c.
00:23:30:00 - 00:19:36:00 = 00:03:54:01

Is this possible?

Thanks

digit22

 

[shawnwest]

FYI -
NTSC Timecode = 30 frames per second
hh:mm:ss:ff

ff= 00 thru 29
ss=00 thru 59
mm=00 thru 59
hh=00 thru 99

 

[Harald Staff]

Hi

In short : No.
Longer version: Insert timecode as text and have VBA macros and VBA
functions do the parsing and the math.

There are some solutions out there. See
http://groups.google.com/groups?q=excel+timecode&hl=en
but this is usually not spreadsheet work; Excel serves only as VBA host,
display and data storage utility. So consider an application built for
timecode if you're going to do EDLs.

However, logging rarely needs the frames part. Excel works great with
hh:mm:ss .

HTH. Best wishes Harald