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 - gsnu200745


"Gervin Callo" wrote:

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

"Gary''s Student" wrote in message
...
'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


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.
--
Gary''s Student - gsnu200745


"Sandy Mann" wrote:

"Gary''s Student" wrote in message
...
'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


Replace @mailinator.com with @tiscali.co.uk

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
--
Gary''s Student - gsnu200746


"Gervin Callo" wrote:

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