Video Time Code
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 |
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 |
All times are GMT +1. The time now is 10:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com