Video Time Code

[Guest]

I'd like to add columns of hours, minutes, seconds, and frames.

At 30 frames I want to be able to carry over into seconds one second, at 60
seconds I'd like to be able to carry over 1 minute, etc.

How can I do that in columns in Excell?

Smith

 

[Guest]

just convert the frames into normal time. If the values are NTSC frames @
29.97 frames/sec then:
if A1 is 123456 frames then
=A1/29.97 is 4119.319319 seconds and
=A1/29.97/60//60/24 is 0.047677307
If this is formatted as a time it becomes:

01:08:39.32
as hours minute seconds and hundreths of a second