formulas Help in determining the number of working hours and extracting additional hours from them

[abdelfattah]

i have file is equipped table to determine the number of working hours (two terms) and extract them additional hours
I would like to help fill the cells with the appropriate formula with the following notes
1. Official working hours are 8 hours and what has increased is the extra time, and numbers entered at the time of entry and exit system for the two periods are 24 hours
2- Any Friday in which the time is completely extra
3. Vertical cells added in another table and is a names of days, may help in the equation to determine if the calculated full day in the case of a cell "Today the name of" Gomaa or otherwise
(And this column in each month will be different based on the order of days in each month and will be arranged to change every time)
4. There is in another cell total hours Het extra time for the entire

Work Time Sheet.xlsx
	A	B	C	D	E	F	G	H	I	J
1
2				Time Card
3
4			26 XX.2020 To 25 XX.2020
5
6		Morninig		After Noon
7		Log in	Log Out	Log in	Log Out	Hrs worked		OverTime Hours		Day Name
8	26	7:57	12:00	12:30	16:02					Tuesday
9	27	7:50	11:59	12:38	16:08					Wednesday
10	28	7:54	12:02	12:49	17:45					Thursday
11	29	10:56	11:56	12:51	15:44					Friday
12	30	7:40	12:00	12:30	15:30					Saturday
13	31	8:00	12:00	12:30	16:06					Sunday
14
15	1	7:57	12:00	12:30	16:02					Monday
16	2	7:50	11:59	12:38	16:08					Tuesday
17	3	7:54	12:02	12:49	17:45					Wednesday
18	4	7:53	11:54	12:52	18:32					Thursday
19	5	13:00	15:00							Friday
20	6	7:55	12:01	12:32	18:37					Saturday
21	7	7:56	11:56	12:51	18:44					Sunday
22	8	8:02	11:58	12:50	18:04					Monday
23	9	8:08	11:59	12:26	18:02					Tuesday
24	10	7:00	12:09	12:50	16:31					Wednesday
25	11	7:55	11:59	12:50	17:01					Thursday
26	12	7:00	12:09	12:50	16:31					Friday
27	13	7:47	12:02	14:39	16:31					Saturday
28	14	7:29	12:03	14:01	17:52					Sunday
29	15	6:56	12:19	14:39	17:07					Monday
30	16	7:55	11:59	12:50	17:01					Tuesday
31	17	7:00	12:09	12:50	16:31					Wednesday
32	18	7:47	12:02	14:39	16:31					Thursday
33	19	7:29	12:03	14:01	17:52					Friday
34	20	6:56	12:19	14:39	17:07					Saturday
35	21	7:29	12:03	14:01	17:52					Sunday
36	22	6:56	12:19	14:39	17:07					Monday
37	23	7:55	11:59	12:50	17:01					Tuesday
38	24	7:00	12:09	12:50	16:31					Wednesday
39	25	7:47	12:02	14:39	16:31					Thursday
40
41
42		Total OverTime (Hours)
43
44
45
26_XX 2020 To 26_XX 2020

 

[Dave Patton]

If you just need the total for overtime, you can use a formula.
I included an option with a helper column and an option without the helper column.

T202006a.xlsm
	A	B	C	D	E	F	G
7		Log in	Log Out	Log in	Log Out	Hrs worked
8	Tue May-26-20	07:57	12:00	12:30	16:02	7.58	0
7aa

Cell Formulas
Range	Formula
F8	F8	=((C8-B8)+(E8-D8))*24
G8	G8	=--(OR(WEEKDAY(A8,16)=7,ISNUMBER(MATCH(A8,$M$2:$M$97,0))))

T202006a.xlsm
	B	C	D	E	F	G	H
43	OT With helper column G						45.32
44	OT Without helper column						45.32
7aa

Cell Formulas
Range	Formula
H43	H43	=SUMPRODUCT(--(F8:F38>8),--(G8:G38=0),(F8:F38-8))+SUMPRODUCT(--(G8:G38=1),(F8:F38))
H44	H44	=SUMPRODUCT(--(WEEKDAY(A8:A38,16)=7)+ISNUMBER(MATCH(A8:A38,M2:M8,0)),(H8:H38))-SUMPRODUCT(--(WEEKDAY(A8:A38,16)=7),--(F8:F38>8),(F8:F38-8))+SUMPRODUCT(--(F8:F38>8),(F8:F38-8))