View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default timecode calculator

http://groups.google.com/groups?as_q...coring=d&hl=en

--
Regards,
Tom Ogilvy


"Elgin" wrote in message
...
I need a macro or plugin that can perform calculations on timecode.

format = hh:mm:ss:ff
where h = hours (0-60)
m = minutes (0-60)
s = seconds (0-60)
f = frames (0-25) or even better (0-x) where x is a variable

Excel provides one for hh:mm:ss but it is the extra ff field that is

elusive

Does anyone know of such a thing? Or can suggest a bit of vb to do the

job?