Code Required to calculate number of days worked, normal overtime and holiday overtime

[DocAElstein]

Output data range ( AFTER ) for worksheet “121” after running either of the codes
Sub IJAdjustTotalAllWorksheet()
Or
Sub IJAdjustKAddTotalAllWorksheet()




Using Excel 2007 32 bit

Row\Col	A	B	C	D	E	F	G	H	I	J	K
1	SOVEL	JOY	121	TEAM LEADER	21.Dec.16	7:00	18:00	11:00	9:00	2:00	N
2	SOVEL	JOY	121	TEAM LEADER	22.Dec.16	7:00	18:00	11:00	9:00	2:00	N
3	SOVEL	JOY	121	TEAM LEADER	23.Dec.16	7:00	15:00	8:00		8:00	H
4	SOVEL	JOY	121	TEAM LEADER	24.Dec.16	7:00	18:00	11:00	9:00	2:00	N
5	SOVEL	JOY	121	TEAM LEADER	25.Dec.16	7:00	18:00	11:00	9:00	2:00	N
6	SOVEL	JOY	121	TEAM LEADER	26.Dec.16	7:00	18:00	11:00	9:00	2:00	N
7	SOVEL	JOY	121	TEAM LEADER	27.Dec.16	7:00	17:00	10:00	9:00	1:00	N
8	SOVEL	JOY	121	TEAM LEADER	28.Dec.16	7:00	18:00	11:00	9:00	2:00	N
9	SOVEL	JOY	121	TEAM LEADER	29.Dec.16	7:00	18:00	11:00	9:00	2:00	N
10	SOVEL	JOY	121	TEAM LEADER	30.Dec.16	7:00	18:00	11:00		10:00	H
11	SOVEL	JOY	121	TEAM LEADER	31.Dec.16	7:00	18:00	11:00	9:00	2:00	N
12	SOVEL	JOY	121	TEAM LEADER	1.Jan.17	7:00	18:00	11:00	9:00	2:00	N
13	SOVEL	JOY	121	TEAM LEADER	2.Jan.17	7:00	18:00	11:00	9:00	2:00	N
14	SOVEL	JOY	121	TEAM LEADER	3.Jan.17	7:00	18:00	11:00	9:00	2:00	N
15	SOVEL	JOY	121	TEAM LEADER	4.Jan.17	7:00	18:00	11:00	9:00	2:00	N
16	SOVEL	JOY	121	TEAM LEADER	5.Jan.17	7:00	18:00	11:00	9:00	2:00	N
17	SOVEL	JOY	121	TEAM LEADER	6.Jan.17						H
18	SOVEL	JOY	121	TEAM LEADER	7.Jan.17	7:00	18:00	11:00	9:00	2:00	N
19	SOVEL	JOY	121	TEAM LEADER	8.Jan.17	7:00	18:00	11:00	9:00	2:00	N
20	SOVEL	JOY	121	TEAM LEADER	9.Jan.17	7:00	18:00	11:00	9:00	2:00	N
21	SOVEL	JOY	121	TEAM LEADER	10.Jan.17	7:00	18:00	11:00	9:00	2:00	N
22	SOVEL	JOY	121	TEAM LEADER	11.Jan.17	7:00	18:00	11:00	9:00	2:00	N
23	SOVEL	JOY	121	TEAM LEADER	12.Jan.17	7:00	18:00	11:00	9:00	2:00	N
24	SOVEL	JOY	121	TEAM LEADER	13.Jan.17	7:00	18:00	11:00		10:00	H
25	SOVEL	JOY	121	TEAM LEADER	14.Jan.17	7:30	17:30	10:00	9:00	1:00	N
26	SOVEL	JOY	121	TEAM LEADER	15.Jan.17	7:30	17:30	10:00	9:00	1:00	N
27	SOVEL	JOY	121	TEAM LEADER	16.Jan.17	7:30	17:30	10:00	9:00	1:00	N
28	SOVEL	JOY	121	TEAM LEADER	17.Jan.17	7:30	17:30	10:00	9:00	1:00	N
29	SOVEL	JOY	121	TEAM LEADER	18.Jan.17	7:00	18:00	11:00	9:00	2:00	N
30	SOVEL	JOY	121	TEAM LEADER	19.Jan.17	7:00	18:00	11:00	9:00	2:00	N
31	SOVEL	JOY	121	TEAM LEADER	20.Jan.17						H

Worksheet: 121