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

Deepinconsternation

New Member
Joined
Apr 26, 2002
Messages
41
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.
:pray:
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
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
Joined
Apr 26, 2002
Messages
41
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
:pray:
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,097
Messages
5,768,071
Members
425,452
Latest member
htay44

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top