combining multiple cell Calculations

[HappyChappy]

Wages23-24.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
50	Mon 04/03/24			00:00	00:00	00:00	00:00			00:00	00:00				£-	£-		£-		£-			Holiday	0:45	39:00	-	-	wk_03.03.243	D
51	Tue 05/03/24	7:00	16:00	09:00	00:45	08:15	08:15	00:30	08:45	00:00	00:00	£150.65	£0.34	£135.63	£-	£-	£11.55	£3.47	£11.55	£-	20.00			0:45	39:00	£16.44	-	wk_03.03.243	D
52	Wed 06/03/24	7:00	17:00	10:00	00:45	09:15	09:15	00:30	09:45	00:00	00:00	£158.10	£0.39	£151.13	£-	£-	£3.50	£3.47	£12.95	£9.45	20.00	06:45:00		0:45	39:00	£16.34	-	wk_03.03.243	D
53	Thu 07/03/24	7:00	17:00	10:00	00:45	09:15	09:15	00:30	09:45	00:00	00:00	£167.55	£0.39	£151.13	£-	£-	£12.95	£3.47	£12.95	£-	20.00			0:45	39:00	£16.34	-	wk_03.03.243	D
54	Fri 08/03/24	7:00	17:00	10:00	00:45	09:15	09:15	00:30	09:45	00:00	00:00	£167.55	£0.39	£151.13	£-	£-	£12.95	£3.47	£12.95	£-	20.00			0:45	39:00	£16.34	-	wk_03.03.243	D
55	Sat 09/03/24			00:00	00:00	00:00	00:00			00:00	00:00				£-	£-		£-		£-				0:45	39:00	-	-	wk_03.03.243	D
56	Sun 10/03/24			00:00	00:00	00:00	00:00			00:00	00:00				£-	£-		£-		£-				0:45	39:00	-	-	wk_10.03.2410	D
57	Paid On			39:00	03:00	36:00	36:00	02:00	38:00	00:00	00:00	£643.83	£1.50	£589.00	£-	£-	£40.95	£13.88	£50.40	£9.45	80.00					£65.45	£-		D
Data

Cell Formulas
Range	Formula
D50:D56	D50	=IF(COUNT(B50:C50)=2,C50-B50+(B50>C50),0)
E50,E54:E56	E50	=MIN(MAX(0,D50-TIME(8,45,0)),X50)
F50:F56	F50	=MAX(TIME(8,0,0),+D50-E50)*(D50>0)
G50:G56	G50	=MAX(0,MIN(F50,Y50-SUMIF($AB$1:AB49,AB50,$G$1:$G49)))
H50:H56	H50	=IF(OR(B50="",C50=""),"",(1/48))
I50:I56	I50	=IF(OR(B50="",C50=""),"",G50+H50)
J50:J56	J50	=+F50-G50
K50:K56	K50	=IF(D50>0,IF(B50<C50,MAX(0,TIME(7,0,0)-B50)+MAX(0,C50-TIME(17,0,0)),MAX(0,MIN(TIME(7,0,0),C50)+1-MAX(TIME(17,0,0),B50))),0)
L50:L56	L50	=IF(OR(B50="",C50=""),"",SUM(N50:R50))
M50	M50	=IF(OR(B50="",C50=""),"",I50+H50)
N50:N56	N50	=IF(OR(B50="",C50=""),"",24*$I50*VLOOKUP(WEEKDAY($A50,2),Tabel1,3,1))
O50:O56	O50	=24*$J50*VLOOKUP(WEEKDAY($A50,2),Tabel1,4,1)
P50:P56	P50	=K50*1*24
Q50:Q56	Q50	=IF(OR(B50="",C50=""),"",S50-T50)
R50:R56	R50	=IF(OR(D50="",E50=""),"",$U50*VLOOKUP(WEEKDAY($A50,2),Tabel1,6,1))
S50:S56	S50	=IF(OR(C50="",D50=""),"",24*$M50*VLOOKUP(WEEKDAY($A50,2),Tabel1,5,1))
T50:T56	T50	=IF(OR(E50="",F50=""),"",24*$V50*VLOOKUP(WEEKDAY($A50,2),Tabel1,5,1))
E51:E53	E51	=MIN(MAX(0,D51-TIME(7,45,0)),X51)
M51:M56	M51	=IF(OR(B51="",C51=""),"",G51+J51)
Z50:Z56	Z50	=IFERROR(+N50/G50/24,"-")
AA50:AA56	AA50	=IFERROR(+O50/J50/24,"-")
AB50:AB56	AB50	=IF(A50="",AB49,"wk_"& TEXT(A50-WEEKDAY(A50)+1,"dd.mm.yyd"))
A50	A50	=A48+1
A51:A56	A51	=A50+1
D57:Q57,S57:T57,Z57:AA57	D57	=SUBTOTAL(109,D50:D56)
R57	R57	=SUM(R51:R55)
U57	U57	=SUM(U50:U56)
AC50:AC57	AC50	=IF(A50="","T","D")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A57:B57	Expression	=AND($A57<>"",MOD(ROW($A57),2)=0)	text	NO
A50:AB56,D57:AB57	Expression	=AND($A50<>"",MOD(ROW($A50),2)=0)	text	NO
N50:W57	Expression	=AND($A50<>"",N50=0,1)	text	NO
D50:K57	Expression	=AND($A50<>"",D50=0,1)	text	NO

Cells with Data Validation
Cell	Allow	Criteria
B50:C56	Whole number	between 0 and 1

Cant work out how to do the following calculations can anyone help.
need to figure out how to make L show a default figure of £100 if W=Holiday
Need cell I to deduct 30minutes if it see's any information in cell V

 

[Peter_SSs]

Try these
For L

=IF(W50="Holiday",100,IF(OR(B50="",C50=""),"",SUM(N50:R50)))

For I

=IF(OR(B50="",C50=""),"",G50+H50-IF(V50="",0,TIME(0,30,0)))

 

[HappyChappy]

Wow fantastic.....

 

[Peter_SSs]

Thanks for the follow-up.