Can Excel Calculate time down to Frames i.e. Television or Film

[Bill D. Toronto]

I work in Television and I'm trying to figure out if Excel can calculate
total durations the format is being sent to me the following HH:MM:SS.F

Any ideas? It's the age old question of a legacy system managing
information to a second and the new system having a bit more precision.

Many thanks!

Bill

 

[Niek Otten]

Hi Bill,

Look at Johm Walkenbach's TIMEXX group of functions here:

http://www.j-walk.com/ss/pup/pup6/functions.htm


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I work in Television and I'm trying to figure out if Excel can calculate
| total durations the format is being sent to me the following HH:MM:SS.F
|
| Any ideas? It's the age old question of a legacy system managing
| information to a second and the new system having a bit more precision.
|
| Many thanks!
|
| Bill