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

  • Thread starter Thread starter Bill D. Toronto
  • Start date Start date
B

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
 
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
 
Back
Top