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]

i'm almost sure that's not possible, but i have no experience with mobile phones.
So, it's perhaps better to open a new question here on the site about that.
Maybe, somebody else knows a workaround ...

 

[HappyChappy]

Have been using your spread sheet and its been great but the company have decided to change things, they cant leave well alone.
Monday to friday now from 06:00-18:00 standard rate £18ph 18:00-06:00 £19ph this bit is easy to adjust but now they also want after 8 hours rate to be £22ph is this some thing that can be changed easily by reworking formula in column J

 

[BSALV]

??? those "48 normal hours / week" is history, now it's a "06:00-18:00" job with overtime before and after ?
And pause ?

 

[HappyChappy]

Yes the 48hr has been replaced by the new system. So if I started at 10:00 till 20:00 10:00-18:00 at £18ph 18:00-20:00 at £22 have just asked about the break deduction of .45 mins that comes off at the standard rate of £18ph
So overtime is worked out anything over 8 hrs

 

[BSALV]

is the break 12:00-12:45 or 1/2 hour after 4 hours or ...
if it's too difficult, it'll be an UDF, so not suitable on a mobile phone.

 

[HappyChappy]

is the break 12:00-12:45 or 1/2 hour after 4 hours or ...
if it's too difficult, it'll be an UDF, so not suitable on a mobile phone.

Break can be anytime in the shift and is deducted at .45 minutes

 

[BSALV]

after 8 hours, there is a break of max 45 minutes
version2

 

[HappyChappy]

just had a look it seems good apart from if you work less than 8hrs ie: 5.45 it should always pay a min of 8 hours pay
also the new overtime calculations are only for monday to friday
all day Saturday is paid at £22ph
all day sunday is paid at £30ph
all day bank holiday is paid at £31ph

many thanks

 

[BSALV]

version2

 

[HappyChappy]

looks the business thank you once again