Small construction based monthly job/invoice tracker

[Fegal]

Hi All

I am trying to build a Monthly invoicing spreadsheet using data from timesheet.
I cannot find examples of what I need and am stuck, if you could point me in the right direction it would be greatly appreciated.
The times worked in this sheet need to be translated into a monthly sheet where i can see at a snap what jobs were worked on during any month (could be 5-10 jobs) how many hours under each employee and what the total invoice amount is, then an invoiced check.....

Timesheets.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
2
3
4
5		Rates					James					Michael
6	Job	Builder	Apprentice				Start	Stop	Time	Job		Start	Stop	Time	Job
7	Crawford	65	40			1/05/2023	07:30	17:00	9.00
8	Crawford Extras	65	40			1/05/2023	07:30	17:00	9.00
9	Auckland rd Lot 1	65	40			1/05/2023
10	Auckland Rd Lot 2	65	40			1/05/2023
11	Auckland Rd extras	65	40			2/05/2023
12						2/05/2023
13						2/05/2023
14						3/05/2023
15						3/05/2023
16						3/05/2023
17						4/05/2023
18						4/05/2023
19						4/05/2023
20						5/05/2023
21						5/05/2023
22						5/05/2023
23						6/05/2023
24						6/05/2023
25						6/05/2023
26						7/05/2023
27						7/05/2023
28						7/05/2023
29						8/05/2023
30						8/05/2023
31						8/05/2023
32						9/05/2023
33						9/05/2023
34						9/05/2023
35						10/05/2023
36						10/05/2023
37						10/05/2023
38						11/05/2023
39						11/05/2023
40						11/05/2023
Time Sheet

Cell Formulas
Range	Formula
J7:J40,O7:O40	J7	=IF(H7="","",(I7-H7)*24-0.5)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G7:G749	Expression	=ISNUMBER(VLOOKUP(G7:G251,Public,1,0))	text	NO
G7:G749	Expression	=WEEKDAY(G7,2)>5	text	NO

Cells with Data Validation
Cell	Allow	Criteria
K7:K40	List	=$B$7:$B$24
P7:P40	List	=$B$7:$B$24