Thread: Video Time Code
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Video Time Code

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


"Smith" wrote:

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