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

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




"mgarcia" wrote in
message ...

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

Thanks Peo! Just what I needed. :)

-Mgarcia


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

Thanks for the feedback

--
Regards,

Peo Sjoblom

Portland, Oregon




"mgarcia" wrote in
message ...

Thanks Peo! Just what I needed. :)

-Mgarcia


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