View Single Post
  #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