is it possible

[HappyChappy]

Exel.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	January		Hours Worked			Total Hours	Total Pay
2	Sunday	30/01/2022	00:00	00:00	00:00	0:00
3	Monday	31/01/2022	10:00	20:00	10:00	9:15	£92.50
4	Tuesday	01/02/2022	10:00	20:00	10:00	9:15	£92.50
5	Wednesday	02/02/2022	10:00	20:15	10:15	9:30	£95.00
6	Thursday	03/02/2022	10:00	14:00	04:00	4:00	£80.00
7	Friday	04/02/2022	10:00	20:00	10:00	9:15	£92.50
8	Saturday	05/02/2022	10:00	16:00	06:00	6:00	£120.00
9
10
11	RATES
12	£10.00	Standard Rate			Min 8 hrs paid as in G6 once 48 is reached Overtime kicks in to all paymnts
13	£15.00	O/Time Rate
14	£12.00	Saturday Rate
15	£18.00	Saturday O/Time Rate
16	£15.00	Sunday Rate
17	£22.00	Sunday O/Time Rate
18
Jan-22

Cell Formulas
Range	Formula
E2:E8	E2	=D2-C2
F2:F8	F2	=IF(E2>TIME(8,0,),E2-TIME(0,45,0),E2)
G2	G2	=IF(F2=0,"",MAX(Data!$B$44,F2*24)*$A$14)
G3:G7	G3	=IF(F3=0,"",MAX(Data!$B$44,F3*24)*$A$12)
G8	G8	=IF(F8=0,"",MAX(Data!$B$44,F8*24)*$A$16)
B3:B8	B3	=B2+1

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

Trying to work out how to build in hours work over 48 at overtime rate. The sheet can work out minimum hours works of 8hr also breaks of 45 mins need to be factored in once 8:45 is reached
i hope i have pasted the mini sheet correctly as it's my first attempt at this thank you

 

[BSALV]

wages
is it correct that employers and employees use another tax-scale ?
Thus the calculation is different in Y and AC ?

 

[HappyChappy]

The calculations are done at different times in the equation so the amounts differ. But in July the amount will change from £190 before tax to £240 so will need a different reference hence I thought one called tax and maybe one called tax1 and I can change the cells accordingly after that date.

 

[HappyChappy]

Sorry just re read your comment yes the Cash thresholds are one thing but the % rate differs its 13.25% on Employees NI and 15.05% on Employers NI

 

[HappyChappy]

like what you did in new spread sheet but an error has crept in if you look at a10 :a16 this should all be charged at STD rate but for some reason its jumped over to O/T rate
it happens in further down the sheet also

 

[BSALV]

done

 

[HappyChappy]

STD and O/T are great now but results are missing in W Y AB AC on updated spreadsheet

 

[BSALV]

i'm lost and hate this kind of calculations !

those 4 columns, do they use STD or O/T ?
Last time it was O/T and O/T is empty.

 

[HappyChappy]

Sorted it in X it refers to M instead of K must of got jumbled with all the changes i gave you.
Can thank you enough for your time and expertise on this project.

 

[BSALV]

done

 

[HappyChappy]

im am using this wonderful spreadsheet and it works great.
the only thing wrong now is on my PC it is fully functional but on the slimmed down version of excel on mobile apps (my phone)
they dont use macro, is there a way round this?