Tape recording time code?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how to create a time code for production recording in Ms Excel?

For Example:

Tc in: 00:01:00:00 Tc out: 01:00:00:00

Hour:minute:second:Frame

Hour = 60
Minute = 60
Second = 60
Frame = 24

What i want is when i enter my Tc in into A1 and Tc out to B1 the result
will be display into C1 for Ms excel...

hoping for reply

ty

GERVIN
 
It depends on the frame rate:

Film (24 frames per second)
PAL (25 fps)
NTSC (29.97 fps)
Digital Video (30 fps)
50 fps
60 fps

Let's look at 30 fps:

In A1 enter:

'11:11:11:10

note single quote in front
10 is 10 frames

in another cell:

=LEFT(A1,2)/24+MID(A1,4,2)/(24*60)+MID(A1,7,2)/(24*60*60)+RIGHT(A1,2)/(24*60*60*30)

format as Custom hh:mm:ss.00
displays:
11:11:11.33
now the 33 is 33 one hundredths of a second.

For film, just use 24 in place of 30 in the formula
 
Gary''s Student said:
'11:11:11:10

note single quote in front
10 is 10 frames
Click to expand...

Ah! I was still trying to figure out that formatting
--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Hi Sandy:

I became frustrated coming up with a format, that's why I put the apostrophe
in front. I figured that I can always dis-assemble a text string and
re-assemble to make a "real" time.
 
COULD YOU PLEASE check the formula u gived because its not working when i
entered there is a msg that the formula you entered contains an error..

or could u pls send me the sample as ms excel format... i need Film (24
frames per second) ..

ty
 
=LEFT(A1,2)/24+MID(A1,4,2)/(1440)+MID(A1,7,2)/(86400)+RIGHT(A1,2)/(2073600)

watchout for any extra wrap characters
 
Back
Top