How can I calculate....

M

mgarcia

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
 
P

Peo Sjoblom

If the average time (0:03:39) is in cell B2

=1/24/B2

formats result as general returns 16.44921552436
given that he cannot use decimal moves I'd suggest you
round down

=FLOOR(1/24/B2,1)

16 moves per hour

--
Regards,

Peo Sjoblom

Portland, Oregon
 
Top