Possible to create a video timecode number format?

B

Brad May

Is is possible to create a custom number format for video
timecodes, e.g. hh:mm:ss:ff where ff is video frames
(range from 0 to 29 for NTSC video or 0 to 23 for PAL)
and hh:mm:ss are the usual hours, minutes and seconds
formats already defined in Excel.
 
H

Harald Staff

It ends up as text on entry. Excel can't calculate this, so you need VBA
functions to do that. Searc Google for several fine solutions.

So I guess the answer is no, no number format for timecode.

Pal is btw 00-24. 23 is (or maybe was) film.

HTH. Best wishes Harald
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Timecode in Excel 2
Video timecode question 3
Video Timecode? 2
Function for hrs:mins:secs:frames for timecode calculations 1
Time Code Format 2
Video Time Format 4
hh:mm:ss.ss Number format 2
changing seconds to timecode 2

Top