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

 

[HappyChappy]

The spreadsheet is great
To make it more versatile Can we add a front which using data validation and index choose weather or not to have breaks deducted yes/no
Also the overtime threshold can be changed from 40,45,48 hours

 

[HappyChappy]

Once again thank you this is fantastic.

 

[HappyChappy]

Just tried the spreadsheet and noticed that the break and overtime thresholds work via validation but that you have to change each day seperatly. Can this be done from a central cell rather than imputing it many times.

 

[BSALV]

As you wanted several overtimes (what were they : 40:00, 45:00 and 48:00), i thought you had several periods in a year with different values or you used this for serveral persons with other parameters.
So you can prepare a calendar for a whole year, and copy and drag this down for that whole year.
If it suddenly changes the 1st of July, then you change it in that row and drag it down for the rest of the year. So you only have to add your start&stop every day.

 

[HappyChappy]

Sorry when i tried to drag down it added 1 to each cell and it put a value in the total column

 

[BSALV]

I tried it myself, sorry, it's not dragging, but copying.
Suppose, in your data without the subtotals (click the green button) and you change the overtime in P20.

* in P20, click CTRL+C (to copy)
* select the wanted P-range, for example P20:P100, click CTRL+V ( to paste)

 

[HappyChappy]

Been trying to use the spreadsheet on my phone and can't see how to hide the search views you have set up on the left edge. Can they be hidden or removed as I lose a third of my screen on the phone cheers

 

[BSALV]

column A is hidden and column B shows the date without weekday
Overtime

 

[HappyChappy]

I like to see the totals at the bottom of each week on the Data sheet it is just the three little boxes that change the view on the left is would like to know how to hide them
the toggle is a nice idea but it only works once then stops

 

[HappyChappy]

wages-22.23.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Date	Start	Finish	Total	Break	Total	Std Rate Hrs	O/T Rate Hours	Night Bonus	Total Pay	Std Rate Payment	O/T Rate Payment	Night Rate Payment	Break +/-	Hrs Before OverTime	Check	Check3
Hours

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
L1:N1000,E1:J1000	Expression	=E1=0	text	NO

i'm loving the spreadsheed so helpful can I just ask to change the titles to English i tried but it effects the pivot table.....