Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 7
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 3,440
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I subtract time where hh:mm:ss:ff (frames = 30 frames/sec) KJ7 Excel Discussion (Misc queries) 14 December 3rd 16 10:03 AM
Need Help with Freezing/Splitting 2 Frames in Excel 2003 Tyn Excel Discussion (Misc queries) 3 February 13th 07 06:19 PM
Frames in Excel with drop down boxes. Adam Excel Discussion (Misc queries) 2 December 31st 06 04:53 PM
Calculation of Hrs and Mins from 2 Time Frames Corey Excel Worksheet Functions 6 May 31st 06 05:12 PM
Film on pda M C via OfficeKB.com Excel Discussion (Misc queries) 1 May 25th 05 05:27 PM


All times are GMT +1. The time now is 12:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"