Hours over basic

[HappyChappy]

Payslip.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Day	Date	Start Time	Finish Time	Hours Worked	Break	Hours Minus Break	Basic Hours	Overtime Hours	Servicing	Bonus Hours	Basic Hours Pay	Bonus Pay	OverTime @1.5	Breakdowns	Bonus Pay lost	Total Bonus Pay	Miles Travelled	Travel Expences	Daily Total
2	Monday	12/02/2024	07:00	17:00	10.00	0.75	9.25	8.30	0.95	0.50	8.75	128.65	12.25	22.09		£0.00	£12.25	20.00	£3.47	£166.46
3	Tuesday	13/02/2024	07:00	17:00	10.00	0.75	9.25	8.30	0.95	0.50	8.75	128.65	12.25	22.09		£0.00	£12.25	20.00	£3.47	£166.46
4	Wednesday	14/02/2024	07:00	17:00	10.00	0.75	9.25	8.30	0.95	0.50	8.75	128.65	12.25	22.09		£0.00	£12.25	20.00	£3.47	£166.46
5	Thursday	15/02/2024	07:00	17:00	10.00	0.75	9.25	8.30	0.95	0.50	8.75	128.65	12.25	22.09		£0.00	£12.25	20.00	£3.47	£166.46
6	Friday	16/02/2024	07:00	17:00	10.00	0.75	9.25	8.30	0.95	0.50	8.75	128.65	12.25	22.09		£0.00	£12.25	20.00	£3.47	£166.46
7	Saturday	17/02/2024
8	Sunday	18/02/2024
9
10
11					50.00	3.75	46.25	41.50	4.75	2.50	43.75	643.25	61.25	110.44	0.00	£0.00	£61.25	100.00	£17.35	£832.29
19.02.24

Cell Formulas
Range	Formula
E2:E8	E2	=IF(OR(C2="",D2=""),"",(D2-C2)*24)
F2:F8	F2	=IF(OR(C2="",D2=""),"",(1/32)*24)
G2:G8	G2	=IF(OR(C2="",D2=""),"",(E2-F2))
I2:I8	I2	=IF(OR(C2="",D2=""),"",G2-H2)
J2:J8	J2	=IF(OR(C2="",D2=""),"",1/48*24)
K2:K8	K2	=IF(OR(C2="",D2=""),"",(E2-F2-J2))
L2:L8	L2	=IF(OR(C2="",D2=""),"",(H2*A$13))
M2:M8	M2	=IF(OR(C2="",D2=""),"",K2*A$15)
N2:N8	N2	=IF(OR(C2="",D2=""),"",I2*A$14)
P2:P8	P2	=IF(OR(C2="",D2=""),"",O2*A$15)
Q2:Q8	Q2	=IF(OR(D2="", C2=""),"",M2-P2)
S2:S8	S2	=IF(OR(C2="",D2=""),"",R2*A$16)
T2:T6	T2	=IF(OR(D2="", C2=""),"",L2+N2+Q2+S2)
T7:T8	T7	=IF(OR(D7="", C7=""),"",#REF!+#REF!+Q7+S7)
B3:B8	B3	=B2+1
E11,G11:I11,T11	E11	=SUM(E2:E8)
F11,J11	F11	=SUM(F2:F7)
K11:S11	K11	=SUM(K2:K6)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2:D9	Cell Value	>0	text	NO

Cells with Data Validation
Cell	Allow	Criteria
O9	List	=$A$18:$A$27

Im paid 39 at flat rate for the week the problem i have is to work it on a daily rate you cant just divide by 5 or 7 so if i have a half day for instance it comes off the whole week figure
anything over the 39 plus 2.5 for servicing giving me 41.50 for a standard week is paid at x1.5 less .75 breaks
so on a 50 hr week 41.50 is at basic rate 4.75 at 1.5 rate totaling 46.25
hope this make sense its beyond my skill level can anyone help.

 

[HappyChappy]

This file please ignore

 

[Fluff]

In future please do not mark a post as the solution, when it does not contain one. Thanks

 

[HappyChappy]

In future please do not mark a post as the solution, when it does not contain one. Thanks

couldn't work out how to delete thread as completely rewritten a new spreadsheet so this question is obsolete.

 

[Fluff]

No need to delete it, post#2 is all that is needed.