# Converting work hours into days

#### Tomkat

##### New Member
Hi,

I have hours worked for employees listed over a monthly period. In the row below I have listed if they have worked their set number of hours for the month, more hours or less hours.

e.g one person has worked 420 hrs, which is their correct number of hours. The second person has worked 462 but their standard hours are 456, and the third person has worked 444 hrs but their set hours are 456.

Can someone please tell me what formula I can use to change the 6 hrs over, 12 hours under etc into days, based on the standard length of each day worked being 7 hours.

Thanks
Kat

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

#### Dave Patton

##### Well-known Member
With named ranges =(Worked-Standard)/Std_Day
With cell references A5 has 7 =(C2-C3)/A5

or =(D2-D3)/Std_Day =(D2-D3)/7 =(D2-D3)/A5

Results 0.86 and (1.71) i.e. -1.71

Thanks Dave.

Replies
11
Views
256
Replies
5
Views
83
Replies
0
Views
106
Replies
2
Views
174
Replies
0
Views
120

1,191,521
Messages
5,987,073
Members
440,074
Latest member
Emmanuelian

### 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.

### Which adblocker are you using?

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