Sort by number with keeping same structure for data

[muhleebbin]

Hi,

I have the following data that gets produced from our timesheet website however it aligns our employees in a funny format. Each employee has an employee number however it sorts all the 1's 10's and 100's first and then so on. Is there a way to resort this data using the employee number as the guide so that it is in numerical order?

Thank you for your assistance!

SUBMITTED TIME REPORT -- 08312020 - Mon - 09062020 - Sun (5).csv
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Date	Job	Employee	Time In	Time Out	Cost Code	Description	Hours	Earn Code	Amount	Approver	Equipment	Qty	Submitted By	Shift	Trade	Phase	Status	Row Modified On
2	1 - A Doe																		Subtotal Hours : 40
3	8/31/2020	Test	1 - A Doe	7:00 AM	3:00 PM	200 - Floor - Tile	-	8	REG	$0.00	Test	-	0	Test	-	-	140 - Hall 1	Approved	09/09/2020 5:51 pm UTC
4	9/1/2020	Test	1 - A Doe	7:15 AM	3:15 PM	200 - Floor - Tile	-	8	REG	$0.00	Test	-	0	Test	-	-	134 - Sauna	Approved	09/09/2020 5:51 pm UTC
5	9/2/2020	Test	1 - A Doe	7:00 AM	3:00 PM	200 - Floor - Tile	-	8	REG	$0.00	Test	-	0	Test	-	-	134 - Sauna	Approved	09/09/2020 5:51 pm UTC
6	9/3/2020	Test	1 - A Doe	7:15 AM	3:15 PM	200 - Floor - Tile	-	8	REG	$0.00	Test	-	0	Test	-	-	121 - Mech. Room	Approved	09/09/2020 5:51 pm UTC
7	9/4/2020	Test	1 - A Doe	7:15 AM	3:15 PM	200 - Floor - Tile	-	8	REG	$0.00	Test	-	0	Test	-	-	121 - Mech. Room	Approved	09/09/2020 5:51 pm UTC
8	107 - B Doe																		Subtotal Hours : 32
9	8/31/2020	Test	107 - B Doe	11:30 AM	3:00 PM	1200 - T&M - Demo Tile	-	3.5	REG	$0.00	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
10	8/31/2020	Test	107 - B Doe	6:30 AM	11:00 AM	1200 - T&M - Demo Tile	-	4.5	REG	$0.00	Test	-	0	Test	-	-	127 - Party Hall Floor	Approved	09/09/2020 5:51 pm UTC
11	9/1/2020	Test	107 - B Doe	11:30 AM	3:00 PM	1200 - T&M - Demo Tile	-	3.5	REG	$0.00	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
12	9/1/2020	Test	107 - B Doe	6:30 AM	11:00 AM	1200 - T&M - Demo Tile	-	4.5	REG	$0.00	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
13	9/2/2020	Test	107 - B Doe	11:30 AM	3:00 PM	1200 - T&M - Demo Tile	-	3.5	REG	$0.00	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
14	9/2/2020	Test	107 - B Doe	6:30 AM	11:00 AM	1200 - T&M - Demo Tile	-	4.5	REG	$0.00	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
15	9/3/2020	Test	107 - B Doe	11:30 AM	3:00 PM	1000 - T&M Tile Prep	-	3.5	REG	$0.00	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
16	9/3/2020	Test	107 - B Doe	6:30 AM	11:00 AM	1200 - T&M - Demo Tile	-	4.5	REG	$0.00	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
17	112 - C Doe																		Subtotal Hours : 49.5
18	8/31/2020	Test	112 - C Doe	7:00 AM	11:00 AM	1 - General Costs	-	4	REG	$0.00	Test	-	0	Test	-	-	1 - NO PHASE	Approved	09/03/2020 12:48 am UTC
19	8/31/2020	Test	112 - C Doe	11:00 AM	4:00 PM	300 - Vanity - Fabrication	-	5	REG	$0.00	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
20	8/31/2020	Test	112 - C Doe	6:00 AM	6:30 AM	210 - Backsplash - Fabrication	-	0.5	REG	$0.00	Test	-	0	Test	-	-	154 - Mudroom	Approved	09/09/2020 5:51 pm UTC
21	8/31/2020	Test	112 - C Doe	6:30 AM	7:00 AM	210 - Backsplash - Fabrication	-	0.5	REG	$0.00	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
22	9/1/2020	Test	112 - C Doe	6:00 AM	1:00 PM	300 - Vanity - Fabrication	-	7	REG	$0.00	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
23	9/1/2020	Test	112 - C Doe	1:00 PM	4:00 PM	310 - Countertop - Fabrication	-	3	REG	$0.00	Test	-	0	Test	-	-	131 - Laundry Room/Mud Room	Approved	09/09/2020 5:51 pm UTC
24	9/2/2020	Test	112 - C Doe	11:30 AM	4:00 PM	206 - Shower - Fabrication	-	4.5	REG	$0.00	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
25	9/2/2020	Test	112 - C Doe	6:00 AM	11:30 AM	300 - Vanity - Fabrication	-	5.5	REG	$0.00	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
26	9/3/2020	Test	112 - C Doe	6:00 AM	7:00 AM	206 - Shower - Fabrication	-	1	REG	$0.00	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
27	9/3/2020	Test	112 - C Doe	7:00 AM	8:00 AM	300 - Vanity - Fabrication	-	1	REG	$0.00	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
28	9/3/2020	Test	112 - C Doe	8:00 AM	9:00 AM	210 - Backsplash - Fabrication	-	1	REG	$0.00	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
29	9/3/2020	Test	112 - C Doe	9:00 AM	4:00 PM	700 - Fireplace - Fabrication	-	7	REG	$0.00	Test	-	0	Test	-	-	107 - Master Bedroom	Approved	09/09/2020 5:51 pm UTC
30	9/4/2020	Test	112 - C Doe	1:00 PM	4:00 PM	20 - Shop and Equipment Maintenance	-	3	REG	$0.00	Test	-	0	Test	-	-	125 - LMT Shop	Approved	09/09/2020 5:51 pm UTC
31	9/4/2020	Test	112 - C Doe	6:00 AM	8:00 AM	700 - Fireplace - Fabrication	-	2	REG	$0.00	Test	-	0	Test	-	-	107 - Master Bedroom	Approved	09/09/2020 5:51 pm UTC
32	9/4/2020	Test	112 - C Doe	8:00 AM	12:30 PM	207 - Tub Wall- Fabrication	-	4.5	REG	$0.00	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
33	114 - E Doe																		Subtotal Hours : 39
34	8/31/2020	Test	114 - E Doe	11:30 AM	3:00 PM	1201 - T&M - Install Tile & Coping	-	3.5	REG	$0.00	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
35	8/31/2020	Test	114 - E Doe	6:30 AM	11:00 AM	1201 - T&M - Install Tile & Coping	-	4.5	REG	$0.00	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
36	9/1/2020	Test	114 - E Doe	11:30 AM	3:00 PM	1201 - T&M - Install Tile & Coping	-	3.5	REG	$0.00	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
37	9/1/2020	Test	114 - E Doe	6:30 AM	11:00 AM	1201 - T&M - Install Tile & Coping	-	4.5	REG	$0.00	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
38	9/2/2020	Test	114 - E Doe	11:30 AM	3:00 PM	1201 - T&M - Install Tile & Coping	-	3.5	REG	$0.00	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/03/2020 10:08 am UTC
39	9/2/2020	Test	114 - E Doe	6:30 AM	11:00 AM	1201 - T&M - Install Tile & Coping	-	4.5	REG	$0.00	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/03/2020 10:08 am UTC
40	9/3/2020	Test	114 - E Doe	11:30 AM	3:00 PM	1201 - T&M - Install Tile & Coping	-	3.5	REG	$0.00	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
41	9/3/2020	Test	114 - E Doe	6:30 AM	11:00 AM	1201 - T&M - Install Tile & Coping	-	4.5	REG	$0.00	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
42	9/4/2020	Test	114 - E Doe	6:30 AM	1:30 PM	1201 - T&M - Install Tile & Coping	-	7	REG	$0.00	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
43	14 - F Doe																		Subtotal Hours : 39
44	8/31/2020	Test	14 - F Doe	2:00 PM	3:00 PM	20 - Shop and Equipment Maintenance	-	1	REG	$0.00	Test	-	0	Test	-	-	125 - Lander Maintenance	Approved	09/09/2020 5:51 pm UTC
45	8/31/2020	Test	14 - F Doe	7:00 AM	9:00 AM	20 - Shop and Equipment Maintenance	-	2	REG	$0.00	Test	-	0	Test	-	-	125 - Lander Maintenance	Approved	09/09/2020 5:51 pm UTC
46	8/31/2020	Test	14 - F Doe	9:00 AM	1:00 PM	601 - Tub Surround - Slab	-	4	REG	$0.00	Test	-	0	Test	-	-	103 - Bathroom 2	Approved	09/09/2020 5:51 pm UTC
47	8/31/2020	Test	14 - F Doe	1:00 PM	2:00 PM	10 - Pickups and Delivery	-	1	REG	$0.00	Test	-	0	Test	-	-	155 - Service	Approved	09/09/2020 5:51 pm UTC
48	9/1/2020	Test	14 - F Doe	10:30 AM	12:30 PM	311 - Countertop - Slab	-	2	REG	$0.00	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
49	9/1/2020	Test	14 - F Doe	12:30 PM	2:30 PM	301 - Vanity - Slab	-	2	REG	$0.00	Test	-	0	Test	-	-	103 - Bathroom 2	Approved	09/09/2020 5:51 pm UTC
50	9/1/2020	Test	14 - F Doe	6:30 AM	10:30 AM	601 - Tub Surround - Slab	-	4	REG	$0.00	Test	-	0	Test	-	-	101 - Bathroom 1	Approved	09/09/2020 5:51 pm UTC
51	9/2/2020	Test	14 - F Doe	7:00 AM	11:00 AM	20 - Shop and Equipment Maintenance	-	4	REG	$0.00	Test	-	0	Test	-	-	127 - Forest Maintenance	Approved	09/09/2020 5:51 pm UTC
52	9/2/2020	Test	14 - F Doe	11:00 AM	3:00 PM	311 - Countertop - Slab	-	4	REG	$0.00	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
53	9/3/2020	Test	14 - F Doe	1:00 PM	3:00 PM	321 - Island - Slab	-	2	REG	$0.00	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
54	9/3/2020	Test	14 - F Doe	7:00 AM	1:00 PM	311 - Countertop - Slab	-	6	REG	$0.00	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
55	9/4/2020	Test	14 - F Doe	12:00 PM	2:00 PM	321 - Island - Slab	-	2	REG	$0.00	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
56	9/4/2020	Test	14 - F Doe	7:00 AM	12:00 PM	311 - Countertop - Slab	-	5	REG	$0.00	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
57	143 - G Doe																		Subtotal Hours : 38.5
58	8/31/2020	Test	143 - G Doe	1:00 PM	4:30 PM	402 - Shower - Slab	-	3.5	REG	$0.00	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
59	8/31/2020	Test	143 - G Doe	7:30 AM	12:00 PM	301 - Vanity - Slab	-	4.5	REG	$0.00	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
60	9/1/2020	Test	143 - G Doe	11:30 AM	2:30 PM	211 - Backsplash - Slab	-	3	REG	$0.00	Test	-	0	Test	-	-	105 - Bunk Bath	Approved	09/09/2020 5:51 pm UTC
61	9/1/2020	Test	143 - G Doe	2:30 PM	3:30 PM	402 - Shower - Slab	-	1	REG	$0.00	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
62	9/1/2020	Test	143 - G Doe	7:30 AM	10:30 AM	402 - Shower - Slab	-	3	REG	$0.00	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
63	9/2/2020	Test	143 - G Doe	2:00 PM	4:00 PM	402 - Shower - Slab	-	2	REG	$0.00	Test	-	0	Test	-	-	104 - Master 4 Bath	Approved	09/09/2020 5:51 pm UTC
64	9/2/2020	Test	143 - G Doe	7:30 AM	9:00 AM	301 - Vanity - Slab	-	1.5	REG	$0.00	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
65	9/2/2020	Test	143 - G Doe	9:00 AM	12:00 PM	402 - Shower - Slab	-	3	REG	$0.00	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
66	9/3/2020	Test	143 - G Doe	3:30 PM	4:15 PM	402 - Shower - Slab	-	0.75	REG	$0.00	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
67	9/3/2020	Test	143 - G Doe	7:00 AM	9:00 AM	402 - Shower - Slab	-	2	REG	$0.00	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
68	9/3/2020	Test	143 - G Doe	9:00 AM	3:30 PM	301 - Vanity - Slab	-	6.5	REG	$0.00	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
69	9/4/2020	Test	143 - G Doe	12:15 PM	4:00 PM	601 - Tub Surround - Slab	-	3.75	REG	$0.00	Test	-	0	Test	-	-	101 - Camp Bath	Approved	09/09/2020 5:51 pm UTC
70	9/4/2020	Test	143 - G Doe	7:15 AM	11:15 AM	402 - Shower - Slab	-	4	REG	$0.00	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
SUBMITTED TIME REPORT -- 083120

 

[sandy666]

like this ?
btw. update your profile about Excel version

Date	Job	Employee	Time In	Time Out	Cost Code	Description	Hours	Earn Code	Amount	Approver	Equipment	Qty	Submitted By	Shift	Trade	Phase	Status	Row Modified On
09/02/2020	Test	1 - A Doe	07:00:00	15:00:00	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	134 - Sauna	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	1 - A Doe	07:15:00	15:15:00	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	121 - Mech. Room	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	1 - A Doe	07:15:00	15:15:00	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	121 - Mech. Room	Approved	09/09/2020 5:51 pm UTC
1 - A Doe																		Subtotal Hours : 40
8/31/2020	Test	1 - A Doe	07:00:00	15:00:00	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	140 - Hall 1	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	1 - A Doe	07:15:00	15:15:00	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	134 - Sauna	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	14 - F Doe	13:00:00	15:00:00	321 - Island - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	14 - F Doe	11:00:00	15:00:00	311 - Countertop - Slab	-	4	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	14 - F Doe	07:00:00	11:00:00	20 - Shop and Equipment Maintenance	-	4	REG	0	Test	-	0	Test	-	-	127 - Forest Maintenance	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	14 - F Doe	07:00:00	13:00:00	311 - Countertop - Slab	-	6	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	14 - F Doe	09:00:00	13:00:00	601 - Tub Surround - Slab	-	4	REG	0	Test	-	0	Test	-	-	103 - Bathroom 2	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	14 - F Doe	07:00:00	12:00:00	311 - Countertop - Slab	-	5	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	14 - F Doe	12:00:00	14:00:00	321 - Island - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
14 - F Doe																		Subtotal Hours : 39
8/31/2020	Test	14 - F Doe	14:00:00	15:00:00	20 - Shop and Equipment Maintenance	-	1	REG	0	Test	-	0	Test	-	-	125 - Lander Maintenance	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	14 - F Doe	07:00:00	09:00:00	20 - Shop and Equipment Maintenance	-	2	REG	0	Test	-	0	Test	-	-	125 - Lander Maintenance	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	14 - F Doe	13:00:00	14:00:00	10 - Pickups and Delivery	-	1	REG	0	Test	-	0	Test	-	-	155 - Service	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	14 - F Doe	06:30:00	10:30:00	601 - Tub Surround - Slab	-	4	REG	0	Test	-	0	Test	-	-	101 - Bathroom 1	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	14 - F Doe	12:30:00	14:30:00	301 - Vanity - Slab	-	2	REG	0	Test	-	0	Test	-	-	103 - Bathroom 2	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	14 - F Doe	10:30:00	12:30:00	311 - Countertop - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	107 - B Doe	06:30:00	11:00:00	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	107 - B Doe	11:30:00	15:00:00	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	107 - B Doe	06:30:00	11:00:00	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	107 - B Doe	11:30:00	15:00:00	1000 - T&M Tile Prep	-	3.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	107 - B Doe	11:30:00	15:00:00	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	107 - B Doe	06:30:00	11:00:00	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
107 - B Doe																		Subtotal Hours : 32
8/31/2020	Test	107 - B Doe	11:30:00	15:00:00	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	107 - B Doe	06:30:00	11:00:00	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	127 - Party Hall Floor	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	112 - C Doe	07:00:00	11:00:00	1 - General Costs	-	4	REG	0	Test	-	0	Test	-	-	1 - NO PHASE	Approved	09/03/2020 12:48 am UTC
112 - C Doe																		Subtotal Hours : 49.5
09/02/2020	Test	112 - C Doe	11:30:00	16:00:00	206 - Shower - Fabrication	-	4.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	112 - C Doe	11:00:00	16:00:00	300 - Vanity - Fabrication	-	5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	112 - C Doe	06:00:00	11:30:00	300 - Vanity - Fabrication	-	5.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	112 - C Doe	06:00:00	07:00:00	206 - Shower - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	112 - C Doe	07:00:00	08:00:00	300 - Vanity - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	112 - C Doe	06:00:00	13:00:00	300 - Vanity - Fabrication	-	7	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	112 - C Doe	13:00:00	16:00:00	310 - Countertop - Fabrication	-	3	REG	0	Test	-	0	Test	-	-	131 - Laundry Room/Mud Room	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	112 - C Doe	06:30:00	07:00:00	210 - Backsplash - Fabrication	-	0.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	112 - C Doe	06:00:00	08:00:00	700 - Fireplace - Fabrication	-	2	REG	0	Test	-	0	Test	-	-	107 - Master Bedroom	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	112 - C Doe	08:00:00	12:30:00	207 - Tub Wall- Fabrication	-	4.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	112 - C Doe	06:00:00	06:30:00	210 - Backsplash - Fabrication	-	0.5	REG	0	Test	-	0	Test	-	-	154 - Mudroom	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	112 - C Doe	08:00:00	09:00:00	210 - Backsplash - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	112 - C Doe	09:00:00	16:00:00	700 - Fireplace - Fabrication	-	7	REG	0	Test	-	0	Test	-	-	107 - Master Bedroom	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	112 - C Doe	13:00:00	16:00:00	20 - Shop and Equipment Maintenance	-	3	REG	0	Test	-	0	Test	-	-	125 - LMT Shop	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	114 - E Doe	11:30:00	15:00:00	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	114 - E Doe	06:30:00	11:00:00	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	114 - E Doe	06:30:00	11:00:00	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
114 - E Doe																		Subtotal Hours : 39
8/31/2020	Test	114 - E Doe	11:30:00	15:00:00	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	114 - E Doe	06:30:00	11:00:00	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	114 - E Doe	06:30:00	13:30:00	1201 - T&M - Install Tile & Coping	-	7	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	114 - E Doe	11:30:00	15:00:00	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	114 - E Doe	11:30:00	15:00:00	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/03/2020 10:08 am UTC
09/02/2020	Test	114 - E Doe	06:30:00	11:00:00	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/03/2020 10:08 am UTC
09/03/2020	Test	143 - G Doe	15:30:00	16:15:00	402 - Shower - Slab	-	0.75	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	143 - G Doe	09:00:00	12:00:00	402 - Shower - Slab	-	3	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	143 - G Doe	07:30:00	09:00:00	301 - Vanity - Slab	-	1.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	143 - G Doe	07:00:00	09:00:00	402 - Shower - Slab	-	2	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	143 - G Doe	07:15:00	11:15:00	402 - Shower - Slab	-	4	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	143 - G Doe	12:15:00	16:00:00	601 - Tub Surround - Slab	-	3.75	REG	0	Test	-	0	Test	-	-	101 - Camp Bath	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	143 - G Doe	09:00:00	15:30:00	301 - Vanity - Slab	-	6.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	143 - G Doe	07:30:00	12:00:00	301 - Vanity - Slab	-	4.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	143 - G Doe	13:00:00	16:30:00	402 - Shower - Slab	-	3.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
143 - G Doe																		Subtotal Hours : 38.5
09/01/2020	Test	143 - G Doe	11:30:00	14:30:00	211 - Backsplash - Slab	-	3	REG	0	Test	-	0	Test	-	-	105 - Bunk Bath	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	143 - G Doe	14:00:00	16:00:00	402 - Shower - Slab	-	2	REG	0	Test	-	0	Test	-	-	104 - Master 4 Bath	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	143 - G Doe	07:30:00	10:30:00	402 - Shower - Slab	-	3	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	143 - G Doe	14:30:00	15:30:00	402 - Shower - Slab	-	1	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC

 

[Bo_Ry]

Please try at
T2 =-LOOKUP(0,-LEFT(IF(C2="",C3,C2),{1,2,3,4,5}))
then sort Column T

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Date	Job	Employee	Time In	Time Out	Cost Code	Description	Hours	Earn Code	Amount	Approver	Equipment	Qty	Submitted By	Shift	Trade	Phase	Status	Row Modified On	Sort
2	1 - A Doe																		Subtotal Hours : 40	1
3	8/31/2020	Test	1 - A Doe	0.29166667	0.625	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	140 - Hall 1	Approved	09/09/2020 5:51 pm UTC	1
4	09-01-20	Test	1 - A Doe	0.30208333	0.63541667	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	134 - Sauna	Approved	09/09/2020 5:51 pm UTC	1
5	09-02-20	Test	1 - A Doe	0.29166667	0.625	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	134 - Sauna	Approved	09/09/2020 5:51 pm UTC	1
6	09-03-20	Test	1 - A Doe	0.30208333	0.63541667	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	121 - Mech. Room	Approved	09/09/2020 5:51 pm UTC	1
7	09-04-20	Test	1 - A Doe	0.30208333	0.63541667	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	121 - Mech. Room	Approved	09/09/2020 5:51 pm UTC	1
8	14 - F Doe																		Subtotal Hours : 39	14
9	8/31/2020	Test	14 - F Doe	0.58333333	0.625	20 - Shop and Equipment Maintenance	-	1	REG	0	Test	-	0	Test	-	-	125 - Lander Maintenance	Approved	09/09/2020 5:51 pm UTC	14
10	8/31/2020	Test	14 - F Doe	0.29166667	0.375	20 - Shop and Equipment Maintenance	-	2	REG	0	Test	-	0	Test	-	-	125 - Lander Maintenance	Approved	09/09/2020 5:51 pm UTC	14
11	8/31/2020	Test	14 - F Doe	0.375	0.54166667	601 - Tub Surround - Slab	-	4	REG	0	Test	-	0	Test	-	-	103 - Bathroom 2	Approved	09/09/2020 5:51 pm UTC	14
12	8/31/2020	Test	14 - F Doe	0.54166667	0.58333333	10 - Pickups and Delivery	-	1	REG	0	Test	-	0	Test	-	-	155 - Service	Approved	09/09/2020 5:51 pm UTC	14
13	09-01-20	Test	14 - F Doe	0.4375	0.52083333	311 - Countertop - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
14	09-01-20	Test	14 - F Doe	0.52083333	0.60416667	301 - Vanity - Slab	-	2	REG	0	Test	-	0	Test	-	-	103 - Bathroom 2	Approved	09/09/2020 5:51 pm UTC	14
15	09-01-20	Test	14 - F Doe	0.27083333	0.4375	601 - Tub Surround - Slab	-	4	REG	0	Test	-	0	Test	-	-	101 - Bathroom 1	Approved	09/09/2020 5:51 pm UTC	14
16	09-02-20	Test	14 - F Doe	0.29166667	0.45833333	20 - Shop and Equipment Maintenance	-	4	REG	0	Test	-	0	Test	-	-	127 - Forest Maintenance	Approved	09/09/2020 5:51 pm UTC	14
17	09-02-20	Test	14 - F Doe	0.45833333	0.625	311 - Countertop - Slab	-	4	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
18	09-03-20	Test	14 - F Doe	0.54166667	0.625	321 - Island - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
19	09-03-20	Test	14 - F Doe	0.29166667	0.54166667	311 - Countertop - Slab	-	6	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
20	09-04-20	Test	14 - F Doe	0.5	0.58333333	321 - Island - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
21	09-04-20	Test	14 - F Doe	0.29166667	0.5	311 - Countertop - Slab	-	5	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
22	107 - B Doe																		Subtotal Hours : 32	107
23	8/31/2020	Test	107 - B Doe	0.47916667	0.625	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	107
24	8/31/2020	Test	107 - B Doe	0.27083333	0.45833333	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	127 - Party Hall Floor	Approved	09/09/2020 5:51 pm UTC	107
25	09-01-20	Test	107 - B Doe	0.47916667	0.625	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	107
26	09-01-20	Test	107 - B Doe	0.27083333	0.45833333	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	107
27	09-02-20	Test	107 - B Doe	0.47916667	0.625	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC	107
28	09-02-20	Test	107 - B Doe	0.27083333	0.45833333	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC	107
29	09-03-20	Test	107 - B Doe	0.47916667	0.625	1000 - T&M Tile Prep	-	3.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC	107
30	09-03-20	Test	107 - B Doe	0.27083333	0.45833333	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC	107
31	112 - C Doe																		Subtotal Hours : 49.5	112
32	8/31/2020	Test	112 - C Doe	0.29166667	0.45833333	1 - General Costs	-	4	REG	0	Test	-	0	Test	-	-	1 - NO PHASE	Approved	09/03/2020 12:48 am UTC	112
33	8/31/2020	Test	112 - C Doe	0.45833333	0.66666667	300 - Vanity - Fabrication	-	5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
34	8/31/2020	Test	112 - C Doe	0.25	0.27083333	210 - Backsplash - Fabrication	-	0.5	REG	0	Test	-	0	Test	-	-	154 - Mudroom	Approved	09/09/2020 5:51 pm UTC	112
35	8/31/2020	Test	112 - C Doe	0.27083333	0.29166667	210 - Backsplash - Fabrication	-	0.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	112
36	09-01-20	Test	112 - C Doe	0.25	0.54166667	300 - Vanity - Fabrication	-	7	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
37	09-01-20	Test	112 - C Doe	0.54166667	0.66666667	310 - Countertop - Fabrication	-	3	REG	0	Test	-	0	Test	-	-	131 - Laundry Room/Mud Room	Approved	09/09/2020 5:51 pm UTC	112
38	09-02-20	Test	112 - C Doe	0.47916667	0.66666667	206 - Shower - Fabrication	-	4.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
39	09-02-20	Test	112 - C Doe	0.25	0.47916667	300 - Vanity - Fabrication	-	5.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
40	09-03-20	Test	112 - C Doe	0.25	0.29166667	206 - Shower - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
41	09-03-20	Test	112 - C Doe	0.29166667	0.33333333	300 - Vanity - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
42	09-03-20	Test	112 - C Doe	0.33333333	0.375	210 - Backsplash - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
43	09-03-20	Test	112 - C Doe	0.375	0.66666667	700 - Fireplace - Fabrication	-	7	REG	0	Test	-	0	Test	-	-	107 - Master Bedroom	Approved	09/09/2020 5:51 pm UTC	112
44	09-04-20	Test	112 - C Doe	0.54166667	0.66666667	20 - Shop and Equipment Maintenance	-	3	REG	0	Test	-	0	Test	-	-	125 - LMT Shop	Approved	09/09/2020 5:51 pm UTC	112
45	09-04-20	Test	112 - C Doe	0.25	0.33333333	700 - Fireplace - Fabrication	-	2	REG	0	Test	-	0	Test	-	-	107 - Master Bedroom	Approved	09/09/2020 5:51 pm UTC	112
46	09-04-20	Test	112 - C Doe	0.33333333	0.52083333	207 - Tub Wall- Fabrication	-	4.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
47	114 - E Doe																		Subtotal Hours : 39	114
48	8/31/2020	Test	114 - E Doe	0.47916667	0.625	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
49	8/31/2020	Test	114 - E Doe	0.27083333	0.45833333	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
50	09-01-20	Test	114 - E Doe	0.47916667	0.625	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
51	09-01-20	Test	114 - E Doe	0.27083333	0.45833333	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
52	09-02-20	Test	114 - E Doe	0.47916667	0.625	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/03/2020 10:08 am UTC	114
53	09-02-20	Test	114 - E Doe	0.27083333	0.45833333	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/03/2020 10:08 am UTC	114
54	09-03-20	Test	114 - E Doe	0.47916667	0.625	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
55	09-03-20	Test	114 - E Doe	0.27083333	0.45833333	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
56	09-04-20	Test	114 - E Doe	0.27083333	0.5625	1201 - T&M - Install Tile & Coping	-	7	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
57	143 - G Doe																		Subtotal Hours : 38.5	143
58	8/31/2020	Test	143 - G Doe	0.54166667	0.6875	402 - Shower - Slab	-	3.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
59	8/31/2020	Test	143 - G Doe	0.3125	0.5	301 - Vanity - Slab	-	4.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
60	09-01-20	Test	143 - G Doe	0.47916667	0.60416667	211 - Backsplash - Slab	-	3	REG	0	Test	-	0	Test	-	-	105 - Bunk Bath	Approved	09/09/2020 5:51 pm UTC	143
61	09-01-20	Test	143 - G Doe	0.60416667	0.64583333	402 - Shower - Slab	-	1	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
62	09-01-20	Test	143 - G Doe	0.3125	0.4375	402 - Shower - Slab	-	3	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
63	09-02-20	Test	143 - G Doe	0.58333333	0.66666667	402 - Shower - Slab	-	2	REG	0	Test	-	0	Test	-	-	104 - Master 4 Bath	Approved	09/09/2020 5:51 pm UTC	143
64	09-02-20	Test	143 - G Doe	0.3125	0.375	301 - Vanity - Slab	-	1.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
65	09-02-20	Test	143 - G Doe	0.375	0.5	402 - Shower - Slab	-	3	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
66	09-03-20	Test	143 - G Doe	0.64583333	0.67708333	402 - Shower - Slab	-	0.75	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	143
67	09-03-20	Test	143 - G Doe	0.29166667	0.375	402 - Shower - Slab	-	2	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
68	09-03-20	Test	143 - G Doe	0.375	0.64583333	301 - Vanity - Slab	-	6.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	143
69	09-04-20	Test	143 - G Doe	0.51041667	0.66666667	601 - Tub Surround - Slab	-	3.75	REG	0	Test	-	0	Test	-	-	101 - Camp Bath	Approved	09/09/2020 5:51 pm UTC	143
70	09-04-20	Test	143 - G Doe	0.30208333	0.46875	402 - Shower - Slab	-	4	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	143
Sheet1

Cell Formulas
Range	Formula
T2:T70	T2	=-LOOKUP(0,-LEFT(IF(C2="",C3,C2),{1,2,3,4,5}))

 

[muhleebbin]

Pretty much, however "1 - A Doe" falls in between their dates on line 5. I'd like to keep the format (dates together) for some additional macros that are in the worksheet that calculates total hours, OT and PTO.

I'll include excel versions in the future as it changes depending on if i'm using a work computer, co workers etc.

This version is Excel for Microsoft 365

like this ?
btw. update your profile about Excel version

Date	Job	Employee	Time In	Time Out	Cost Code	Description	Hours	Earn Code	Amount	Approver	Equipment	Qty	Submitted By	Shift	Trade	Phase	Status	Row Modified On
09/02/2020	Test	1 - A Doe	07:00:00	15:00:00	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	134 - Sauna	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	1 - A Doe	07:15:00	15:15:00	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	121 - Mech. Room	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	1 - A Doe	07:15:00	15:15:00	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	121 - Mech. Room	Approved	09/09/2020 5:51 pm UTC
1 - A Doe																		Subtotal Hours : 40
8/31/2020	Test	1 - A Doe	07:00:00	15:00:00	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	140 - Hall 1	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	1 - A Doe	07:15:00	15:15:00	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	134 - Sauna	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	14 - F Doe	13:00:00	15:00:00	321 - Island - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	14 - F Doe	11:00:00	15:00:00	311 - Countertop - Slab	-	4	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	14 - F Doe	07:00:00	11:00:00	20 - Shop and Equipment Maintenance	-	4	REG	0	Test	-	0	Test	-	-	127 - Forest Maintenance	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	14 - F Doe	07:00:00	13:00:00	311 - Countertop - Slab	-	6	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	14 - F Doe	09:00:00	13:00:00	601 - Tub Surround - Slab	-	4	REG	0	Test	-	0	Test	-	-	103 - Bathroom 2	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	14 - F Doe	07:00:00	12:00:00	311 - Countertop - Slab	-	5	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	14 - F Doe	12:00:00	14:00:00	321 - Island - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
14 - F Doe																		Subtotal Hours : 39
8/31/2020	Test	14 - F Doe	14:00:00	15:00:00	20 - Shop and Equipment Maintenance	-	1	REG	0	Test	-	0	Test	-	-	125 - Lander Maintenance	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	14 - F Doe	07:00:00	09:00:00	20 - Shop and Equipment Maintenance	-	2	REG	0	Test	-	0	Test	-	-	125 - Lander Maintenance	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	14 - F Doe	13:00:00	14:00:00	10 - Pickups and Delivery	-	1	REG	0	Test	-	0	Test	-	-	155 - Service	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	14 - F Doe	06:30:00	10:30:00	601 - Tub Surround - Slab	-	4	REG	0	Test	-	0	Test	-	-	101 - Bathroom 1	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	14 - F Doe	12:30:00	14:30:00	301 - Vanity - Slab	-	2	REG	0	Test	-	0	Test	-	-	103 - Bathroom 2	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	14 - F Doe	10:30:00	12:30:00	311 - Countertop - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	107 - B Doe	06:30:00	11:00:00	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	107 - B Doe	11:30:00	15:00:00	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	107 - B Doe	06:30:00	11:00:00	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	107 - B Doe	11:30:00	15:00:00	1000 - T&M Tile Prep	-	3.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	107 - B Doe	11:30:00	15:00:00	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	107 - B Doe	06:30:00	11:00:00	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
107 - B Doe																		Subtotal Hours : 32
8/31/2020	Test	107 - B Doe	11:30:00	15:00:00	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	107 - B Doe	06:30:00	11:00:00	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	127 - Party Hall Floor	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	112 - C Doe	07:00:00	11:00:00	1 - General Costs	-	4	REG	0	Test	-	0	Test	-	-	1 - NO PHASE	Approved	09/03/2020 12:48 am UTC
112 - C Doe																		Subtotal Hours : 49.5
09/02/2020	Test	112 - C Doe	11:30:00	16:00:00	206 - Shower - Fabrication	-	4.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	112 - C Doe	11:00:00	16:00:00	300 - Vanity - Fabrication	-	5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	112 - C Doe	06:00:00	11:30:00	300 - Vanity - Fabrication	-	5.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	112 - C Doe	06:00:00	07:00:00	206 - Shower - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	112 - C Doe	07:00:00	08:00:00	300 - Vanity - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	112 - C Doe	06:00:00	13:00:00	300 - Vanity - Fabrication	-	7	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	112 - C Doe	13:00:00	16:00:00	310 - Countertop - Fabrication	-	3	REG	0	Test	-	0	Test	-	-	131 - Laundry Room/Mud Room	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	112 - C Doe	06:30:00	07:00:00	210 - Backsplash - Fabrication	-	0.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	112 - C Doe	06:00:00	08:00:00	700 - Fireplace - Fabrication	-	2	REG	0	Test	-	0	Test	-	-	107 - Master Bedroom	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	112 - C Doe	08:00:00	12:30:00	207 - Tub Wall- Fabrication	-	4.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	112 - C Doe	06:00:00	06:30:00	210 - Backsplash - Fabrication	-	0.5	REG	0	Test	-	0	Test	-	-	154 - Mudroom	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	112 - C Doe	08:00:00	09:00:00	210 - Backsplash - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	112 - C Doe	09:00:00	16:00:00	700 - Fireplace - Fabrication	-	7	REG	0	Test	-	0	Test	-	-	107 - Master Bedroom	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	112 - C Doe	13:00:00	16:00:00	20 - Shop and Equipment Maintenance	-	3	REG	0	Test	-	0	Test	-	-	125 - LMT Shop	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	114 - E Doe	11:30:00	15:00:00	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	114 - E Doe	06:30:00	11:00:00	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	114 - E Doe	06:30:00	11:00:00	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
114 - E Doe																		Subtotal Hours : 39
8/31/2020	Test	114 - E Doe	11:30:00	15:00:00	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	114 - E Doe	06:30:00	11:00:00	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	114 - E Doe	06:30:00	13:30:00	1201 - T&M - Install Tile & Coping	-	7	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	114 - E Doe	11:30:00	15:00:00	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	114 - E Doe	11:30:00	15:00:00	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/03/2020 10:08 am UTC
09/02/2020	Test	114 - E Doe	06:30:00	11:00:00	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/03/2020 10:08 am UTC
09/03/2020	Test	143 - G Doe	15:30:00	16:15:00	402 - Shower - Slab	-	0.75	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	143 - G Doe	09:00:00	12:00:00	402 - Shower - Slab	-	3	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	143 - G Doe	07:30:00	09:00:00	301 - Vanity - Slab	-	1.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	143 - G Doe	07:00:00	09:00:00	402 - Shower - Slab	-	2	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	143 - G Doe	07:15:00	11:15:00	402 - Shower - Slab	-	4	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	143 - G Doe	12:15:00	16:00:00	601 - Tub Surround - Slab	-	3.75	REG	0	Test	-	0	Test	-	-	101 - Camp Bath	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	143 - G Doe	09:00:00	15:30:00	301 - Vanity - Slab	-	6.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	143 - G Doe	07:30:00	12:00:00	301 - Vanity - Slab	-	4.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	143 - G Doe	13:00:00	16:30:00	402 - Shower - Slab	-	3.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
143 - G Doe																		Subtotal Hours : 38.5
09/01/2020	Test	143 - G Doe	11:30:00	14:30:00	211 - Backsplash - Slab	-	3	REG	0	Test	-	0	Test	-	-	105 - Bunk Bath	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	143 - G Doe	14:00:00	16:00:00	402 - Shower - Slab	-	2	REG	0	Test	-	0	Test	-	-	104 - Master 4 Bath	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	143 - G Doe	07:30:00	10:30:00	402 - Shower - Slab	-	3	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	143 - G Doe	14:30:00	15:30:00	402 - Shower - Slab	-	1	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC

 

[muhleebbin]

This totally worked! Is there a way to convert it to a macro?

I'm trying to make it a simple cut and paste for the co worker to put in and I can easily foresee them cutting and pasting the whole sheet and clearing out the formula in column T. I'd like to make it as foolproof as possible.

Please try at
T2 =-LOOKUP(0,-LEFT(IF(C2="",C3,C2),{1,2,3,4,5}))
then sort Column T

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Date	Job	Employee	Time In	Time Out	Cost Code	Description	Hours	Earn Code	Amount	Approver	Equipment	Qty	Submitted By	Shift	Trade	Phase	Status	Row Modified On	Sort
2	1 - A Doe																		Subtotal Hours : 40	1
3	8/31/2020	Test	1 - A Doe	0.29166667	0.625	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	140 - Hall 1	Approved	09/09/2020 5:51 pm UTC	1
4	09-01-20	Test	1 - A Doe	0.30208333	0.63541667	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	134 - Sauna	Approved	09/09/2020 5:51 pm UTC	1
5	09-02-20	Test	1 - A Doe	0.29166667	0.625	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	134 - Sauna	Approved	09/09/2020 5:51 pm UTC	1
6	09-03-20	Test	1 - A Doe	0.30208333	0.63541667	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	121 - Mech. Room	Approved	09/09/2020 5:51 pm UTC	1
7	09-04-20	Test	1 - A Doe	0.30208333	0.63541667	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	121 - Mech. Room	Approved	09/09/2020 5:51 pm UTC	1
8	14 - F Doe																		Subtotal Hours : 39	14
9	8/31/2020	Test	14 - F Doe	0.58333333	0.625	20 - Shop and Equipment Maintenance	-	1	REG	0	Test	-	0	Test	-	-	125 - Lander Maintenance	Approved	09/09/2020 5:51 pm UTC	14
10	8/31/2020	Test	14 - F Doe	0.29166667	0.375	20 - Shop and Equipment Maintenance	-	2	REG	0	Test	-	0	Test	-	-	125 - Lander Maintenance	Approved	09/09/2020 5:51 pm UTC	14
11	8/31/2020	Test	14 - F Doe	0.375	0.54166667	601 - Tub Surround - Slab	-	4	REG	0	Test	-	0	Test	-	-	103 - Bathroom 2	Approved	09/09/2020 5:51 pm UTC	14
12	8/31/2020	Test	14 - F Doe	0.54166667	0.58333333	10 - Pickups and Delivery	-	1	REG	0	Test	-	0	Test	-	-	155 - Service	Approved	09/09/2020 5:51 pm UTC	14
13	09-01-20	Test	14 - F Doe	0.4375	0.52083333	311 - Countertop - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
14	09-01-20	Test	14 - F Doe	0.52083333	0.60416667	301 - Vanity - Slab	-	2	REG	0	Test	-	0	Test	-	-	103 - Bathroom 2	Approved	09/09/2020 5:51 pm UTC	14
15	09-01-20	Test	14 - F Doe	0.27083333	0.4375	601 - Tub Surround - Slab	-	4	REG	0	Test	-	0	Test	-	-	101 - Bathroom 1	Approved	09/09/2020 5:51 pm UTC	14
16	09-02-20	Test	14 - F Doe	0.29166667	0.45833333	20 - Shop and Equipment Maintenance	-	4	REG	0	Test	-	0	Test	-	-	127 - Forest Maintenance	Approved	09/09/2020 5:51 pm UTC	14
17	09-02-20	Test	14 - F Doe	0.45833333	0.625	311 - Countertop - Slab	-	4	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
18	09-03-20	Test	14 - F Doe	0.54166667	0.625	321 - Island - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
19	09-03-20	Test	14 - F Doe	0.29166667	0.54166667	311 - Countertop - Slab	-	6	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
20	09-04-20	Test	14 - F Doe	0.5	0.58333333	321 - Island - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
21	09-04-20	Test	14 - F Doe	0.29166667	0.5	311 - Countertop - Slab	-	5	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
22	107 - B Doe																		Subtotal Hours : 32	107
23	8/31/2020	Test	107 - B Doe	0.47916667	0.625	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	107
24	8/31/2020	Test	107 - B Doe	0.27083333	0.45833333	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	127 - Party Hall Floor	Approved	09/09/2020 5:51 pm UTC	107
25	09-01-20	Test	107 - B Doe	0.47916667	0.625	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	107
26	09-01-20	Test	107 - B Doe	0.27083333	0.45833333	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	107
27	09-02-20	Test	107 - B Doe	0.47916667	0.625	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC	107
28	09-02-20	Test	107 - B Doe	0.27083333	0.45833333	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC	107
29	09-03-20	Test	107 - B Doe	0.47916667	0.625	1000 - T&M Tile Prep	-	3.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC	107
30	09-03-20	Test	107 - B Doe	0.27083333	0.45833333	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC	107
31	112 - C Doe																		Subtotal Hours : 49.5	112
32	8/31/2020	Test	112 - C Doe	0.29166667	0.45833333	1 - General Costs	-	4	REG	0	Test	-	0	Test	-	-	1 - NO PHASE	Approved	09/03/2020 12:48 am UTC	112
33	8/31/2020	Test	112 - C Doe	0.45833333	0.66666667	300 - Vanity - Fabrication	-	5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
34	8/31/2020	Test	112 - C Doe	0.25	0.27083333	210 - Backsplash - Fabrication	-	0.5	REG	0	Test	-	0	Test	-	-	154 - Mudroom	Approved	09/09/2020 5:51 pm UTC	112
35	8/31/2020	Test	112 - C Doe	0.27083333	0.29166667	210 - Backsplash - Fabrication	-	0.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	112
36	09-01-20	Test	112 - C Doe	0.25	0.54166667	300 - Vanity - Fabrication	-	7	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
37	09-01-20	Test	112 - C Doe	0.54166667	0.66666667	310 - Countertop - Fabrication	-	3	REG	0	Test	-	0	Test	-	-	131 - Laundry Room/Mud Room	Approved	09/09/2020 5:51 pm UTC	112
38	09-02-20	Test	112 - C Doe	0.47916667	0.66666667	206 - Shower - Fabrication	-	4.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
39	09-02-20	Test	112 - C Doe	0.25	0.47916667	300 - Vanity - Fabrication	-	5.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
40	09-03-20	Test	112 - C Doe	0.25	0.29166667	206 - Shower - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
41	09-03-20	Test	112 - C Doe	0.29166667	0.33333333	300 - Vanity - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
42	09-03-20	Test	112 - C Doe	0.33333333	0.375	210 - Backsplash - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
43	09-03-20	Test	112 - C Doe	0.375	0.66666667	700 - Fireplace - Fabrication	-	7	REG	0	Test	-	0	Test	-	-	107 - Master Bedroom	Approved	09/09/2020 5:51 pm UTC	112
44	09-04-20	Test	112 - C Doe	0.54166667	0.66666667	20 - Shop and Equipment Maintenance	-	3	REG	0	Test	-	0	Test	-	-	125 - LMT Shop	Approved	09/09/2020 5:51 pm UTC	112
45	09-04-20	Test	112 - C Doe	0.25	0.33333333	700 - Fireplace - Fabrication	-	2	REG	0	Test	-	0	Test	-	-	107 - Master Bedroom	Approved	09/09/2020 5:51 pm UTC	112
46	09-04-20	Test	112 - C Doe	0.33333333	0.52083333	207 - Tub Wall- Fabrication	-	4.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
47	114 - E Doe																		Subtotal Hours : 39	114
48	8/31/2020	Test	114 - E Doe	0.47916667	0.625	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
49	8/31/2020	Test	114 - E Doe	0.27083333	0.45833333	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
50	09-01-20	Test	114 - E Doe	0.47916667	0.625	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
51	09-01-20	Test	114 - E Doe	0.27083333	0.45833333	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
52	09-02-20	Test	114 - E Doe	0.47916667	0.625	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/03/2020 10:08 am UTC	114
53	09-02-20	Test	114 - E Doe	0.27083333	0.45833333	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/03/2020 10:08 am UTC	114
54	09-03-20	Test	114 - E Doe	0.47916667	0.625	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
55	09-03-20	Test	114 - E Doe	0.27083333	0.45833333	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
56	09-04-20	Test	114 - E Doe	0.27083333	0.5625	1201 - T&M - Install Tile & Coping	-	7	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
57	143 - G Doe																		Subtotal Hours : 38.5	143
58	8/31/2020	Test	143 - G Doe	0.54166667	0.6875	402 - Shower - Slab	-	3.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
59	8/31/2020	Test	143 - G Doe	0.3125	0.5	301 - Vanity - Slab	-	4.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
60	09-01-20	Test	143 - G Doe	0.47916667	0.60416667	211 - Backsplash - Slab	-	3	REG	0	Test	-	0	Test	-	-	105 - Bunk Bath	Approved	09/09/2020 5:51 pm UTC	143
61	09-01-20	Test	143 - G Doe	0.60416667	0.64583333	402 - Shower - Slab	-	1	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
62	09-01-20	Test	143 - G Doe	0.3125	0.4375	402 - Shower - Slab	-	3	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
63	09-02-20	Test	143 - G Doe	0.58333333	0.66666667	402 - Shower - Slab	-	2	REG	0	Test	-	0	Test	-	-	104 - Master 4 Bath	Approved	09/09/2020 5:51 pm UTC	143
64	09-02-20	Test	143 - G Doe	0.3125	0.375	301 - Vanity - Slab	-	1.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
65	09-02-20	Test	143 - G Doe	0.375	0.5	402 - Shower - Slab	-	3	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
66	09-03-20	Test	143 - G Doe	0.64583333	0.67708333	402 - Shower - Slab	-	0.75	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	143
67	09-03-20	Test	143 - G Doe	0.29166667	0.375	402 - Shower - Slab	-	2	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
68	09-03-20	Test	143 - G Doe	0.375	0.64583333	301 - Vanity - Slab	-	6.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	143
69	09-04-20	Test	143 - G Doe	0.51041667	0.66666667	601 - Tub Surround - Slab	-	3.75	REG	0	Test	-	0	Test	-	-	101 - Camp Bath	Approved	09/09/2020 5:51 pm UTC	143
70	09-04-20	Test	143 - G Doe	0.30208333	0.46875	402 - Shower - Slab	-	4	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	143
Sheet1

Cell Formulas
Range	Formula
T2:T70	T2	=-LOOKUP(0,-LEFT(IF(C2="",C3,C2),{1,2,3,4,5}))

 

[sandy666]

I'll include excel versions in the future as it changes depending on if i'm using a work computer, co workers etc.

you can choose more than one version

btw. your table is not proper because in date column you've text (mixed type of data)

 

[sandy666]

see this

Date	Job	Employee	Time In	Time Out	Cost Code	Description	Hours	Earn Code	Amount	Approver	Equipment	Qty	Submitted By	Shift	Trade	Phase	Status	Row Modified On
1 - A Doe		1 - A Doe																Subtotal Hours : 40
8/31/2020	Test	1 - A Doe	07:00:00	15:00:00	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	140 - Hall 1	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	1 - A Doe	07:15:00	15:15:00	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	134 - Sauna	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	1 - A Doe	07:00:00	15:00:00	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	134 - Sauna	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	1 - A Doe	07:15:00	15:15:00	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	121 - Mech. Room	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	1 - A Doe	07:15:00	15:15:00	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	121 - Mech. Room	Approved	09/09/2020 5:51 pm UTC
14 - F Doe		14 - F Doe																Subtotal Hours : 39
8/31/2020	Test	14 - F Doe	14:00:00	15:00:00	20 - Shop and Equipment Maintenance	-	1	REG	0	Test	-	0	Test	-	-	125 - Lander Maintenance	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	14 - F Doe	07:00:00	09:00:00	20 - Shop and Equipment Maintenance	-	2	REG	0	Test	-	0	Test	-	-	125 - Lander Maintenance	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	14 - F Doe	09:00:00	13:00:00	601 - Tub Surround - Slab	-	4	REG	0	Test	-	0	Test	-	-	103 - Bathroom 2	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	14 - F Doe	13:00:00	14:00:00	10 - Pickups and Delivery	-	1	REG	0	Test	-	0	Test	-	-	155 - Service	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	14 - F Doe	10:30:00	12:30:00	311 - Countertop - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	14 - F Doe	12:30:00	14:30:00	301 - Vanity - Slab	-	2	REG	0	Test	-	0	Test	-	-	103 - Bathroom 2	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	14 - F Doe	06:30:00	10:30:00	601 - Tub Surround - Slab	-	4	REG	0	Test	-	0	Test	-	-	101 - Bathroom 1	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	14 - F Doe	07:00:00	11:00:00	20 - Shop and Equipment Maintenance	-	4	REG	0	Test	-	0	Test	-	-	127 - Forest Maintenance	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	14 - F Doe	11:00:00	15:00:00	311 - Countertop - Slab	-	4	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	14 - F Doe	13:00:00	15:00:00	321 - Island - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	14 - F Doe	07:00:00	13:00:00	311 - Countertop - Slab	-	6	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	14 - F Doe	12:00:00	14:00:00	321 - Island - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	14 - F Doe	07:00:00	12:00:00	311 - Countertop - Slab	-	5	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC
107 - B Doe		107 - B Doe																Subtotal Hours : 32
8/31/2020	Test	107 - B Doe	11:30:00	15:00:00	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	107 - B Doe	06:30:00	11:00:00	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	127 - Party Hall Floor	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	107 - B Doe	11:30:00	15:00:00	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	107 - B Doe	06:30:00	11:00:00	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	107 - B Doe	11:30:00	15:00:00	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	107 - B Doe	06:30:00	11:00:00	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	107 - B Doe	11:30:00	15:00:00	1000 - T&M Tile Prep	-	3.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	107 - B Doe	06:30:00	11:00:00	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC
112 - C Doe		112 - C Doe																Subtotal Hours : 49.5
8/31/2020	Test	112 - C Doe	07:00:00	11:00:00	1 - General Costs	-	4	REG	0	Test	-	0	Test	-	-	1 - NO PHASE	Approved	09/03/2020 12:48 am UTC
8/31/2020	Test	112 - C Doe	11:00:00	16:00:00	300 - Vanity - Fabrication	-	5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	112 - C Doe	06:00:00	06:30:00	210 - Backsplash - Fabrication	-	0.5	REG	0	Test	-	0	Test	-	-	154 - Mudroom	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	112 - C Doe	06:30:00	07:00:00	210 - Backsplash - Fabrication	-	0.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	112 - C Doe	06:00:00	13:00:00	300 - Vanity - Fabrication	-	7	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	112 - C Doe	13:00:00	16:00:00	310 - Countertop - Fabrication	-	3	REG	0	Test	-	0	Test	-	-	131 - Laundry Room/Mud Room	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	112 - C Doe	11:30:00	16:00:00	206 - Shower - Fabrication	-	4.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	112 - C Doe	06:00:00	11:30:00	300 - Vanity - Fabrication	-	5.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	112 - C Doe	06:00:00	07:00:00	206 - Shower - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	112 - C Doe	07:00:00	08:00:00	300 - Vanity - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	112 - C Doe	08:00:00	09:00:00	210 - Backsplash - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	112 - C Doe	09:00:00	16:00:00	700 - Fireplace - Fabrication	-	7	REG	0	Test	-	0	Test	-	-	107 - Master Bedroom	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	112 - C Doe	13:00:00	16:00:00	20 - Shop and Equipment Maintenance	-	3	REG	0	Test	-	0	Test	-	-	125 - LMT Shop	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	112 - C Doe	06:00:00	08:00:00	700 - Fireplace - Fabrication	-	2	REG	0	Test	-	0	Test	-	-	107 - Master Bedroom	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	112 - C Doe	08:00:00	12:30:00	207 - Tub Wall- Fabrication	-	4.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
114 - E Doe		114 - E Doe																Subtotal Hours : 39
8/31/2020	Test	114 - E Doe	11:30:00	15:00:00	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	114 - E Doe	06:30:00	11:00:00	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	114 - E Doe	11:30:00	15:00:00	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	114 - E Doe	06:30:00	11:00:00	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	114 - E Doe	11:30:00	15:00:00	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/03/2020 10:08 am UTC
09/02/2020	Test	114 - E Doe	06:30:00	11:00:00	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/03/2020 10:08 am UTC
09/03/2020	Test	114 - E Doe	11:30:00	15:00:00	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	114 - E Doe	06:30:00	11:00:00	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	114 - E Doe	06:30:00	13:30:00	1201 - T&M - Install Tile & Coping	-	7	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC
143 - G Doe		143 - G Doe																Subtotal Hours : 38.5
8/31/2020	Test	143 - G Doe	13:00:00	16:30:00	402 - Shower - Slab	-	3.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
8/31/2020	Test	143 - G Doe	07:30:00	12:00:00	301 - Vanity - Slab	-	4.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	143 - G Doe	11:30:00	14:30:00	211 - Backsplash - Slab	-	3	REG	0	Test	-	0	Test	-	-	105 - Bunk Bath	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	143 - G Doe	14:30:00	15:30:00	402 - Shower - Slab	-	1	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/01/2020	Test	143 - G Doe	07:30:00	10:30:00	402 - Shower - Slab	-	3	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	143 - G Doe	14:00:00	16:00:00	402 - Shower - Slab	-	2	REG	0	Test	-	0	Test	-	-	104 - Master 4 Bath	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	143 - G Doe	07:30:00	09:00:00	301 - Vanity - Slab	-	1.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/02/2020	Test	143 - G Doe	09:00:00	12:00:00	402 - Shower - Slab	-	3	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	143 - G Doe	15:30:00	16:15:00	402 - Shower - Slab	-	0.75	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	143 - G Doe	07:00:00	09:00:00	402 - Shower - Slab	-	2	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC
09/03/2020	Test	143 - G Doe	09:00:00	15:30:00	301 - Vanity - Slab	-	6.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	143 - G Doe	12:15:00	16:00:00	601 - Tub Surround - Slab	-	3.75	REG	0	Test	-	0	Test	-	-	101 - Camp Bath	Approved	09/09/2020 5:51 pm UTC
09/04/2020	Test	143 - G Doe	07:15:00	11:15:00	402 - Shower - Slab	-	4	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC

 

[muhleebbin]

Gotcha, i'll update profile in a sec.

I totally get that the date column has mixed data but unfortunately that's how the website spits out the data.

The next post you have is perfect!

you can choose more than one version

btw. your table is not proper because in date column you've text (mixed type of data)

 

[muhleebbin]

I'm going with your suggestion and I locked every cell I don't want touched and protected the sheet.....they shouldn't be able to break it now ?

Thank you all for your help

Please try at
T2 =-LOOKUP(0,-LEFT(IF(C2="",C3,C2),{1,2,3,4,5}))
then sort Column T

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Date	Job	Employee	Time In	Time Out	Cost Code	Description	Hours	Earn Code	Amount	Approver	Equipment	Qty	Submitted By	Shift	Trade	Phase	Status	Row Modified On	Sort
2	1 - A Doe																		Subtotal Hours : 40	1
3	8/31/2020	Test	1 - A Doe	0.29166667	0.625	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	140 - Hall 1	Approved	09/09/2020 5:51 pm UTC	1
4	09-01-20	Test	1 - A Doe	0.30208333	0.63541667	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	134 - Sauna	Approved	09/09/2020 5:51 pm UTC	1
5	09-02-20	Test	1 - A Doe	0.29166667	0.625	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	134 - Sauna	Approved	09/09/2020 5:51 pm UTC	1
6	09-03-20	Test	1 - A Doe	0.30208333	0.63541667	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	121 - Mech. Room	Approved	09/09/2020 5:51 pm UTC	1
7	09-04-20	Test	1 - A Doe	0.30208333	0.63541667	200 - Floor - Tile	-	8	REG	0	Test	-	0	Test	-	-	121 - Mech. Room	Approved	09/09/2020 5:51 pm UTC	1
8	14 - F Doe																		Subtotal Hours : 39	14
9	8/31/2020	Test	14 - F Doe	0.58333333	0.625	20 - Shop and Equipment Maintenance	-	1	REG	0	Test	-	0	Test	-	-	125 - Lander Maintenance	Approved	09/09/2020 5:51 pm UTC	14
10	8/31/2020	Test	14 - F Doe	0.29166667	0.375	20 - Shop and Equipment Maintenance	-	2	REG	0	Test	-	0	Test	-	-	125 - Lander Maintenance	Approved	09/09/2020 5:51 pm UTC	14
11	8/31/2020	Test	14 - F Doe	0.375	0.54166667	601 - Tub Surround - Slab	-	4	REG	0	Test	-	0	Test	-	-	103 - Bathroom 2	Approved	09/09/2020 5:51 pm UTC	14
12	8/31/2020	Test	14 - F Doe	0.54166667	0.58333333	10 - Pickups and Delivery	-	1	REG	0	Test	-	0	Test	-	-	155 - Service	Approved	09/09/2020 5:51 pm UTC	14
13	09-01-20	Test	14 - F Doe	0.4375	0.52083333	311 - Countertop - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
14	09-01-20	Test	14 - F Doe	0.52083333	0.60416667	301 - Vanity - Slab	-	2	REG	0	Test	-	0	Test	-	-	103 - Bathroom 2	Approved	09/09/2020 5:51 pm UTC	14
15	09-01-20	Test	14 - F Doe	0.27083333	0.4375	601 - Tub Surround - Slab	-	4	REG	0	Test	-	0	Test	-	-	101 - Bathroom 1	Approved	09/09/2020 5:51 pm UTC	14
16	09-02-20	Test	14 - F Doe	0.29166667	0.45833333	20 - Shop and Equipment Maintenance	-	4	REG	0	Test	-	0	Test	-	-	127 - Forest Maintenance	Approved	09/09/2020 5:51 pm UTC	14
17	09-02-20	Test	14 - F Doe	0.45833333	0.625	311 - Countertop - Slab	-	4	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
18	09-03-20	Test	14 - F Doe	0.54166667	0.625	321 - Island - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
19	09-03-20	Test	14 - F Doe	0.29166667	0.54166667	311 - Countertop - Slab	-	6	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
20	09-04-20	Test	14 - F Doe	0.5	0.58333333	321 - Island - Slab	-	2	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
21	09-04-20	Test	14 - F Doe	0.29166667	0.5	311 - Countertop - Slab	-	5	REG	0	Test	-	0	Test	-	-	109 - Kitchen 1	Approved	09/09/2020 5:51 pm UTC	14
22	107 - B Doe																		Subtotal Hours : 32	107
23	8/31/2020	Test	107 - B Doe	0.47916667	0.625	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	107
24	8/31/2020	Test	107 - B Doe	0.27083333	0.45833333	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	127 - Party Hall Floor	Approved	09/09/2020 5:51 pm UTC	107
25	09-01-20	Test	107 - B Doe	0.47916667	0.625	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	107
26	09-01-20	Test	107 - B Doe	0.27083333	0.45833333	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	107
27	09-02-20	Test	107 - B Doe	0.47916667	0.625	1200 - T&M - Demo Tile	-	3.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC	107
28	09-02-20	Test	107 - B Doe	0.27083333	0.45833333	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC	107
29	09-03-20	Test	107 - B Doe	0.47916667	0.625	1000 - T&M Tile Prep	-	3.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC	107
30	09-03-20	Test	107 - B Doe	0.27083333	0.45833333	1200 - T&M - Demo Tile	-	4.5	REG	0	Test	-	0	Test	-	-	109 - Catering Kitchen R106 - Tile	Approved	09/09/2020 5:51 pm UTC	107
31	112 - C Doe																		Subtotal Hours : 49.5	112
32	8/31/2020	Test	112 - C Doe	0.29166667	0.45833333	1 - General Costs	-	4	REG	0	Test	-	0	Test	-	-	1 - NO PHASE	Approved	09/03/2020 12:48 am UTC	112
33	8/31/2020	Test	112 - C Doe	0.45833333	0.66666667	300 - Vanity - Fabrication	-	5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
34	8/31/2020	Test	112 - C Doe	0.25	0.27083333	210 - Backsplash - Fabrication	-	0.5	REG	0	Test	-	0	Test	-	-	154 - Mudroom	Approved	09/09/2020 5:51 pm UTC	112
35	8/31/2020	Test	112 - C Doe	0.27083333	0.29166667	210 - Backsplash - Fabrication	-	0.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	112
36	09-01-20	Test	112 - C Doe	0.25	0.54166667	300 - Vanity - Fabrication	-	7	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
37	09-01-20	Test	112 - C Doe	0.54166667	0.66666667	310 - Countertop - Fabrication	-	3	REG	0	Test	-	0	Test	-	-	131 - Laundry Room/Mud Room	Approved	09/09/2020 5:51 pm UTC	112
38	09-02-20	Test	112 - C Doe	0.47916667	0.66666667	206 - Shower - Fabrication	-	4.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
39	09-02-20	Test	112 - C Doe	0.25	0.47916667	300 - Vanity - Fabrication	-	5.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
40	09-03-20	Test	112 - C Doe	0.25	0.29166667	206 - Shower - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
41	09-03-20	Test	112 - C Doe	0.29166667	0.33333333	300 - Vanity - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
42	09-03-20	Test	112 - C Doe	0.33333333	0.375	210 - Backsplash - Fabrication	-	1	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
43	09-03-20	Test	112 - C Doe	0.375	0.66666667	700 - Fireplace - Fabrication	-	7	REG	0	Test	-	0	Test	-	-	107 - Master Bedroom	Approved	09/09/2020 5:51 pm UTC	112
44	09-04-20	Test	112 - C Doe	0.54166667	0.66666667	20 - Shop and Equipment Maintenance	-	3	REG	0	Test	-	0	Test	-	-	125 - LMT Shop	Approved	09/09/2020 5:51 pm UTC	112
45	09-04-20	Test	112 - C Doe	0.25	0.33333333	700 - Fireplace - Fabrication	-	2	REG	0	Test	-	0	Test	-	-	107 - Master Bedroom	Approved	09/09/2020 5:51 pm UTC	112
46	09-04-20	Test	112 - C Doe	0.33333333	0.52083333	207 - Tub Wall- Fabrication	-	4.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	112
47	114 - E Doe																		Subtotal Hours : 39	114
48	8/31/2020	Test	114 - E Doe	0.47916667	0.625	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
49	8/31/2020	Test	114 - E Doe	0.27083333	0.45833333	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
50	09-01-20	Test	114 - E Doe	0.47916667	0.625	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
51	09-01-20	Test	114 - E Doe	0.27083333	0.45833333	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
52	09-02-20	Test	114 - E Doe	0.47916667	0.625	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/03/2020 10:08 am UTC	114
53	09-02-20	Test	114 - E Doe	0.27083333	0.45833333	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/03/2020 10:08 am UTC	114
54	09-03-20	Test	114 - E Doe	0.47916667	0.625	1201 - T&M - Install Tile & Coping	-	3.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
55	09-03-20	Test	114 - E Doe	0.27083333	0.45833333	1201 - T&M - Install Tile & Coping	-	4.5	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
56	09-04-20	Test	114 - E Doe	0.27083333	0.5625	1201 - T&M - Install Tile & Coping	-	7	REG	0	Test	-	0	Test	-	-	1 - Existing Pool	Approved	09/09/2020 5:51 pm UTC	114
57	143 - G Doe																		Subtotal Hours : 38.5	143
58	8/31/2020	Test	143 - G Doe	0.54166667	0.6875	402 - Shower - Slab	-	3.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
59	8/31/2020	Test	143 - G Doe	0.3125	0.5	301 - Vanity - Slab	-	4.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
60	09-01-20	Test	143 - G Doe	0.47916667	0.60416667	211 - Backsplash - Slab	-	3	REG	0	Test	-	0	Test	-	-	105 - Bunk Bath	Approved	09/09/2020 5:51 pm UTC	143
61	09-01-20	Test	143 - G Doe	0.60416667	0.64583333	402 - Shower - Slab	-	1	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
62	09-01-20	Test	143 - G Doe	0.3125	0.4375	402 - Shower - Slab	-	3	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
63	09-02-20	Test	143 - G Doe	0.58333333	0.66666667	402 - Shower - Slab	-	2	REG	0	Test	-	0	Test	-	-	104 - Master 4 Bath	Approved	09/09/2020 5:51 pm UTC	143
64	09-02-20	Test	143 - G Doe	0.3125	0.375	301 - Vanity - Slab	-	1.5	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
65	09-02-20	Test	143 - G Doe	0.375	0.5	402 - Shower - Slab	-	3	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
66	09-03-20	Test	143 - G Doe	0.64583333	0.67708333	402 - Shower - Slab	-	0.75	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	143
67	09-03-20	Test	143 - G Doe	0.29166667	0.375	402 - Shower - Slab	-	2	REG	0	Test	-	0	Test	-	-	101 - Master 2 Bath	Approved	09/09/2020 5:51 pm UTC	143
68	09-03-20	Test	143 - G Doe	0.375	0.64583333	301 - Vanity - Slab	-	6.5	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	143
69	09-04-20	Test	143 - G Doe	0.51041667	0.66666667	601 - Tub Surround - Slab	-	3.75	REG	0	Test	-	0	Test	-	-	101 - Camp Bath	Approved	09/09/2020 5:51 pm UTC	143
70	09-04-20	Test	143 - G Doe	0.30208333	0.46875	402 - Shower - Slab	-	4	REG	0	Test	-	0	Test	-	-	102 - Master Bathroom	Approved	09/09/2020 5:51 pm UTC	143
Sheet1

Cell Formulas
Range	Formula
T2:T70	T2	=-LOOKUP(0,-LEFT(IF(C2="",C3,C2),{1,2,3,4,5}))

 

[Fluff]

How about

Sub muhleebbin()
   Range("T1").Value = "sort"
   With Range("T2:T" & Range("A" & Rows.Count).End(xlUp).Row)
      .Value = Evaluate(Replace(Replace("if(@<>"""",left(@,find("" "",@)),left(#,find("" "",#)))", "@", .Offset(, -17).Address), "#", .Offset(1, -17).Address))
   End With
   Range("a1").CurrentRegion.Sort Range("T1"), xlAscending, , , , , , xlYes
End Sub