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