Tape recording time code?

[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

 

[Guest]

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

 

[Sandy Mann]

'11:11:11:10

note single quote in front
10 is 10 frames

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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

watchout for any extra wrap characters