ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Can Excel Calculate time down to Frames i.e. Television or Film (https://www.excelbanter.com/setting-up-configuration-excel/180383-can-excel-calculate-time-down-frames-i-e-television-film.html)

Bill D. Toronto[_2_]

Can Excel Calculate time down to Frames i.e. Television or Film
 
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

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

Look at Johm Walkenbach's TIMEXX group of functions he

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bill D. Toronto" wrote in message
...
|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




All times are GMT +1. The time now is 01:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com