LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
mgarcia
 
Posts: n/a
Default How can I calculate....


I have a report that shows the following four columns for numerous
drivers:

Driver01 - Moves - Total Time - Avg Time per move
AA12345 - 747 - 45:24:45 - 03:39

I would like to take the "Avg Time" and figure out what would be the
number of moves this driver could do per hour. Problem is I cannot
figure out how to get Excel to calculate this. I may be putting too
much thought into it, but if someone could please help out I would
appreciate it.

Thank you!
mgarcia


--
mgarcia
------------------------------------------------------------------------
mgarcia's Profile: http://www.excelforum.com/member.php...o&userid=30584
View this thread: http://www.excelforum.com/showthread...hreadid=509667

 
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
Calculate Hours and overtime by week gregt812 Excel Worksheet Functions 1 November 23rd 05 07:03 PM
how to calculate a cube root kiran Rajguru New Users to Excel 2 November 16th 05 10:50 AM
Spreadsheet Won't Calculate Scott Excel Discussion (Misc queries) 0 September 29th 05 05:37 PM
Not able to calculate. mark_kramarczyk Excel Worksheet Functions 1 December 29th 04 08:55 PM
How do you calculate the nth root of a number in Excel 2003? William Excel Worksheet Functions 2 November 17th 04 04:19 PM


All times are GMT +1. The time now is 05:20 PM.

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

About Us

"It's about Microsoft Excel"