Excel-Average completed per hour 2

[SirLaugha1ot]

I am trying to figure out how to take a time (i.e. "8:04" for time spent-not the actual time) and amount completed (i.e. 65) and figure out how many were completed per hour.

The time spent comes from the difference between the start and stop times.

My problem is that I cannot figure out how to have 8:04 represented as 8 hours and 4 minutes so I can divide it with the amount completed and receive the true number instead of some crazy number. For my sake, I hope that makes sense!

 

[acron]

If you have 8:04 (as text) in A1, try

= 65/(TIMEVALUE(A1)*24)

If you have it entered as an actual time use

=65/(A1*24), but make sure you format the result with a number format suxh as "#,##0".

A.C.

 

[SirLaugha1ot]

The cell is formatted for military time. When I switched it to text, it turned into a decimal value and the result using the formula you supplied gave me #VALUE.

Here is an example of what I have...I'm trying to get it to calculate how many jobs were completed per hour.

Start 15:52
Stop 22:59
Difference 8:07
# Completed 65
Jobs per hour ???

 

[DeLaMartre]

Good Morning SirLaughalot,

I believe the following formula works for your purposes:

=#Completed/((Stop-Start)*24)

Just make sure the format in the resulting cell is "Number".

Please let me know if this helps.

-Bob in California

 

[coachdan]

Bob in California's code will work, but you need to place single quotes around the # Completed.

='#Completed'/((Stop-Start)*24)

 

[SirLaugha1ot]

Worked like a charm - Thanks everyone!