Find Moves Per Hour

realniceguy5000

Board Regular
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

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Asator

Board Regular
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

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

realniceguy5000

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

Thanks Again, Mike

Replies
2
Views
440
Replies
0
Views
90
Replies
9
Views
164
Replies
3
Views
206
Replies
4
Views
227

1,191,191
Messages
5,985,216
Members
439,948
Latest member
Xearo96

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back