Find Moves Per Hour

[realniceguy5000]

Hi, I have a speadsheet that lists the pickers moves they did for the day and it also lists the hours they worked / day. My moves / hr column is not calculating the moves per hour correctly. For example:

Col A: Names
Col B: Hours / Day
Col C: Moves Completed
Col D: Moves/Hr


Col B is formated as time custom h:mm
Col C is Formated as a General
Col D Formula is =IF(ISERROR(C5/B5),"",C5/B5)


Col B value is 9:00
Col C value is 313
Col D value is 834.69 When it should be more like 34.78 moves / Hr.

Can someone advise what is wrong?

Thank You, Mike

 

[Asator]

Date/time is stored as a single number. One day = 1, so one hour = 1/24. You need to multiply your 9:00 (.37) by 24.

 

[Scott R]

Col D Formula is =IF(ISERROR(C5/B5),"",C5/B5/24)

 

[realniceguy5000]

Thank You guys, It's working now as I changed the cell value to *24 and set the formatting to general

Thanks Again, Mike