Summarizing Data from Table

[SpreadsheetSwaff]

First time posting here. I'm looking for some help on how to summarize a table that is being used to track overtime coverage. The whole goal is to document how much Leadership coverage we have for any given weekend. This is something that each leader will be inputting their time into this spreadsheet. I am open to better ways of trying to handle this data. I love working in excel and i am trying to learn new tips and tricks along the way. I appreciate any and all feedback.


CURRENT:

OT Leadership Coverage.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	TVS Weekend Coverage
2	Please enter your working hours for leadership weekend coverage below. Two (2) weekends on this list were skipped, Thanksgiving and Christmas. If you are not able to provide coverage, please put a dash " - " in the cell. Feel free to enter future coverage if you know it.
3	Notes for the Weekend Of	10/15/2021	In Department 1 at the moment we have XX people coming in Friday from 3:20am – 8:00pm Friday Night Saturday: Sunday Night:
4	Date	User1	User2	User3	User4	User5	User6	User7	User8	User9	User10	User11	User12	User13	User14	User15	User16
11	October 15, 2021 - Friday	7am-noon	-	8am-12pm	-	-	-	5am-9am	-	-	-	-	-	10a-2:30p	8am-12pm	-	5am-9am
12	October 16, 2021 - Saturday	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
13	October 17, 2021 - Sunday	-	-	6pm-8pm		-	-	-	-	-	-	-	-	-	-	-	-
14	October 22, 2021 - Friday			8am-12pm	6am-10am
15	October 23, 2021 - Saturday
16	October 24, 2021 - Sunday
17	October 29, 2021 - Friday			8am-12pm					2pm-6pm		-
18	October 30, 2021 - Saturday										-
19	October 31, 2021 - Sunday										-
20	November 05, 2021 - Friday			8am-12pm			8am-12pm
21	November 06, 2021 - Saturday
22	November 07, 2021 - Sunday
23	November 12, 2021 - Friday		8am-12:30pm
24	November 13, 2021 - Saturday
25	November 14, 2021 - Sunday
26	November 19, 2021 - Friday									-	-		9am - 1pm		-
27	November 20, 2021 - Saturday									-	-				-
28	November 21, 2021 - Sunday										-				-
29	December 03, 2021 - Friday														8am-12pm
30	December 04, 2021 - Saturday														-
31	December 05, 2021 - Sunday														-
32	December 10, 2021 - Friday				6am-10am
33	December 11, 2021 - Saturday
34	December 12, 2021 - Sunday
35	December 17, 2021 - Friday								2pm-6pm		-
36	December 18, 2021 - Saturday										-
37	December 19, 2021 - Sunday										-
38	January 07, 2022 - Friday						8am - 12pm
39	January 08, 2022 - Saturday
40	January 09, 2022 - Sunday
Therapeutic Weekend Coverage

Cell Formulas
Range	Formula
B3	B3	=NOW() - WEEKDAY(NOW(),3)+4

FORMAT GOAL:

OT Leadership Coverage.xlsx
	E	F	G
19	Date	Name	Coverage
20	October 15, 2021 - Friday	User 1	7am-noon
21		User 2	8am-12pm
22	October 22, 2021 - Friday	User 3	6am-10am
23		User 4	8am-12pm
24	October 29, 2021 - Friday	User 3	2pm-6pm
25		User 4	8am-12pm
26	November 05, 2021 - Friday	User 6	8am-12pm
27		User 4	8am-12pm
28	November 06, 2021 - Saturday	User 1	7-12pm
29	November 12, 2021 - Friday	User 3	8am-12:30pm
Data - Per Line