Differential based on percentage of hourly rate between set range hours

[DamnBrecklyn]

Please point me in the right direction. I'm trying to factor in differential pay for hours between 10pm - 6am.
Differential =10% hourly wage. Example employee makes $10 an hour so differential would equal $1 totaling $11/hr for any hours worked between 10pm - 6p

What formula designate between 10-6 the employee get paid hourly + differential

xxTimesheet1.xlsx
	A	B	C	D	E	F	G	H	I
4						date	10/10/21
5
6	Wage	$14.75
7	OT Wage	$22.13
8
9	Day	Date	Time in	Time Out	Time In	Time Out	OT In	OT Out	Total
10	Sunday	10-Oct-21	6:00 AM	11:00 AM	12:00 PM	3:00 PM	10:00 PM	12:00 AM	10.00
11	Monday	11-Oct-21	3:00 AM	8:00 AM	9:00 AM	12:00 PM	8:00 PM	10:00 PM	10.00
12	Tuesday	12-Oct-21	1:00 AM	5:00 AM	6:00 AM	10:00 AM			8.00
13	Wednesday	13-Oct-21	9:00 PM	1:00 AM	2:00 AM	6:00 AM			8.00
14	Thursday	14-Oct-21	9:00 PM	1:00 AM	2:00 AM	6:00 AM	10:00 PM	11:00 PM	9.00
15	Friday	15-Oct-21					6:00 PM	9:00 PM	3.00
16	Saturday	16-Oct-21							0.00
TimeSheet

Cell Formulas
Range	Formula
B7	B7	=B6*1.5
B10	B10	=G4
B11:B16	B11	=B10+1
I10:I16	I10	=(MOD(D10-C10,1)+MOD(F10-E10,1)+MOD(H10-G10,1))*24

 

[DamnBrecklyn]

testing now

 

[DamnBrecklyn]

Formula for Differential is as below

=10%*B6*24*SUMPRODUCT(MMULT((MOD("6:00"-"22:00",1)>MOD(C10:D16-"22:00",1))*MOD("6:00"-C10:D16,1)+(MOD("6:00"-"22:00",1)>MOD(E10:F16-"22:00",1))*MOD("6:00"-E10:F16,1)+(MOD("6:00"-"22:00",1)>MOD(G10:H16-"22:00",1))*MOD("6:00"-G10:H16,1),{1;-1})+MOD("6:00"-"22:00",1)*((MOD(C10:C16-"22:00",1)>MOD(D10:D16-"22:00",1))+(MOD(E10:E16-"22:00",1)>MOD(F10:F16-"22:00",1))+(MOD(G10:G16-"22:00",1)>MOD(H10:H16-"22:00",1))))

Works thank you!!!