Time Code Calculator on Excel and How To Use It

This is the Time Code Calculator. If you have any questions or would like to request a copy then please either leave a comment or send me a message with your email address and I'll get back to you ASAP.

It helps when using the TCC if you have a media log.

I also find this useful as a post-log.

There are a few glitches that still need ironing out, if you have fixed any glitches or would like to try to then please send me a message.

If you use tape based media and have Time Code breaks in your tape then this calculator can still be used, but be extra careful when labelling clips and Time Codes.

Video capture software I used: http://www.hyperionics.com/hc/
Webcam (Microphone) I used: http://www.minoru3d.com/

Category:

Howto & Style

Tags:

• Timecode
• time
• code
• calculator
• film
• tv
• television
• broadcast
• pal
• NTSC
• footage
• media
• log
• editing
• software
• calculation
• maths
• math
• mathematics
• coding

[tomaskas]

@wamtecpro Hi, the email address provided is bouncing back with an sending failure. Are you sure this is the correct address?

[tomaskas]

@Wrendercow Thanks for this. I later learned why this is broadcast standard. At the time of recording I had no idea. Hope you enjoyed the video! :)

[eliya6000]

I would love a copy of your excel document, if you could email it to eliya@wagtv.com I'd be very happy.

thanks!

[wamtecpro]

can i have an email of this doc bro.i am to shoot a documentry for my yeartwo exam this will get me much organised well Thanks for the good work.wamtecpro@yahoo.co.uk

[DarkVisionPictures]

Thank you for the informative video! Exactly what I need! Keep up the good work!

[Wrendercow]

*** Starting the Hour at "01" Instead of "00"

Most professional video applications start time code at one hour (01:00:00:00) to allow for pre-program information.

- Any footage before 01:00:00:00 is _not_ meant for the audience to see.

- Any footage after 01:00:00:00 is meant for the audience to see.

With tape based post production, it's common to put color bars and tone as well as a slate before the picture start. Starting at hour one allows for this.

[Wrendercow]

*** NTSC's Frame Rate (29.97 fps and 30 fps)

For NTSC, you would want to use either "29.97" for drop frame time code or "30" for non-drop frame time code.

Broadcast NTSC must use drop frame time code. As such, two frames are renumbered - or "dropped" - per minute except for every 10th minute to keep the the duration of the program consistent with a real world clock so that when an hour has passed in time code an hour has passed on the clock.

[yatishw]

can i get copy or some help please