ExcelBanter - 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?