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

[Deepinconsternation]

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:

 

[Brian from Maui]

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]

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
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1						40.00	HoursWorkedperweek
2	StartDate	FinishDate	Weeks&Days	WeeklyWageRate	Numberofweeks	No.ofHours	No.ofMinutes		GrossWeeklyWage
3	1-Jan-04	1-Feb-04	42/5	100.00	4	16	0		$440.00
4						abovetoequal16@40hrspwk	abovetoequal0@40hrspwk		shouldequal$440.00whenformulaiscorrectedusinghourandminutes
5
6
7
8									WEEK	4days	3days	2days	1DAY
9		Thisisa"workinprogress".TheTableontherightassisteduserstocalculatethecorrecthoursandminutesforsomeHoursworkedperWeekformanualdataentry.Overall,itdoescalculatecorrectlytothecentbutisnotflexibleenough.							40	32	24	16	8
10									FALSE	FALSE	FALSE	FALSE	FALSE
11									FALSE	FALSE	FALSE	FALSE	FALSE
12									FALSE	FALSE	FALSE	FALSE	FALSE
13									FALSE	FALSE	FALSE	FALSE	FALSE
14
Sheet1