# Convert Hours Minutes worked per week to weeks, hours and mi

#### Deepinconsternation

##### New Member
Purpose is to calculate the arrears of gross wage based on a normal working week (of variable hours and minutes).
Time start and finish not required. It is assumed that the week is 5 days long but can be 40 hours, 37hr30mins,35hrs,38hrs,20hrs etc long.
So far can calculate weeks and days.
Problem is converting ?/5 (days) to equal ? many hours and ? minutes in different columns based on the hours worked per week.
Spreadsheet is utilised to enter into a Payment System that does not calculate hours or minutes but requires user input of that data. \$calculation of wage is used to compare calculation between Payment system and Excel.
I've done fairly well to get as far as I have but I'll salute an Excel guru who can help with this! I've used NETWORKDAYS to calculate weeks & ?/5 of a week between dates.
ray:

### Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

#### Brian from Maui

##### MrExcel MVP
Re: Convert Hours Minutes worked per week to weeks, hours an

Can you post some sample data and expected results using Colo's utility found at the bottom of this page?

#### Deepinconsternation

##### New Member
Brian from Maui said:
Can you post some sample data and expected results using Colo's utility found at the bottom of this page?
Hve attached file. Thanks.

Thanks. Here it is! Hope you can read it.
Chris
ray:
Arrears sample.xls
ABCDEFGHIJKLMN
140.00HoursWorkedperweek
2StartDateFinishDateWeeks&DaysWeeklyWageRateNumberofweeksNo.ofHoursNo.ofMinutesGrossWeeklyWage
31-Jan-041-Feb-0442/5100.004160\$440.00
4abovetoequal16@40hrspwkabovetoequal0@40hrspwkshouldequal\$440.00whenformulaiscorrectedusinghourandminutes
5
6
7
8WEEK4days3days2days1DAY
9Thisisa"workinprogress".TheTableontherightassisteduserstocalculatethecorrecthoursandminutesforsomeHoursworkedperWeekformanualdataentry.Overall,itdoescalculatecorrectlytothecentbutisnotflexibleenough.403224168
10FALSEFALSEFALSEFALSEFALSE
11FALSEFALSEFALSEFALSEFALSE
12FALSEFALSEFALSEFALSEFALSE
13FALSEFALSEFALSEFALSEFALSE
14
Sheet1

Replies
2
Views
293
Replies
7
Views
509
Replies
1
Views
653
Replies
3
Views
799
Replies
5
Views
65

1,187,180
Messages
5,962,062
Members
438,579
Latest member
fishkeeper

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