Appendix Thread 2. ( Codes for other Threads, HTML Tables, etc.)

[DocAElstein]

After from last two posts after running code :
Sub IJAdjust_LAdd_AbsentKAdd_TotalsFormulas_AllWorkshe etsCode4()



Using Excel 2007 32 bit

Row\Col	C	D	E	F	G	H	I	J	K	L
1	121	TEAM LEADER	21.Dec.16	7:00	18:00	11:00	9:00	2:00		N
2	121	TEAM LEADER	22.Dec.16	7:00	18:00	11:00	9:00	2:00		N
3	121	TEAM LEADER	23.Dec.16	7:00	15:00	8:00		8:00		H
4	121	TEAM LEADER	24.Dec.16	7:00	18:00	11:00	9:00	2:00		N
5	121	TEAM LEADER	25.Dec.16	7:00	18:00	11:00	9:00	2:00		N
6	121	TEAM LEADER	26.Dec.16	7:00	18:00	11:00	9:00	2:00		N
7	121	TEAM LEADER	27.Dec.16	7:00	17:00	10:00	9:00	1:00		N
8	121	TEAM LEADER	28.Dec.16	7:00	18:00	11:00	9:00	2:00		N
9			29.Dec.16						ABSENT	N
10			30.Dec.16						ABSENT
11			31.Dec.16						ABSENT	N
12	121	TEAM LEADER	1.Jan.17	7:00	18:00	11:00	9:00	2:00		N
13	121	TEAM LEADER	2.Jan.17	7:00	18:00	11:00	9:00	2:00		N
14	121	TEAM LEADER	3.Jan.17	7:00	18:00	11:00	9:00	2:00		N
15	121	TEAM LEADER	4.Jan.17	7:00	18:00	11:00	9:00	2:00		N
16	121	TEAM LEADER	5.Jan.17	7:00	18:00	11:00	9:00	2:00		N
17	121	TEAM LEADER	6.Jan.17							H
18	121	TEAM LEADER	7.Jan.17	7:00	18:00	11:00	9:00	2:00		N
19	121	TEAM LEADER	8.Jan.17	7:00	18:00	11:00	9:00	2:00		N
20	121	TEAM LEADER	9.Jan.17						ABSENT	N
21	121	TEAM LEADER	10.Jan.17	7:00	18:00	11:00	9:00	2:00		N
22	121	TEAM LEADER	11.Jan.17	7:00	18:00	11:00	9:00	2:00		N
23	121	TEAM LEADER	12.Jan.17	7:00	18:00	11:00	9:00	2:00		N
24	121	TEAM LEADER	13.Jan.17	7:00	18:00	11:00		10:00		H
25	121	TEAM LEADER	14.Jan.17	7:30	17:30	10:00	9:00	1:00		N
26	121	TEAM LEADER	15.Jan.17	7:30	17:30	10:00	9:00	1:00		N
27	121	TEAM LEADER	16.Jan.17	7:30	17:30	10:00	9:00	1:00		N
28	121	TEAM LEADER	17.Jan.17	7:30	17:30	10:00	9:00	1:00		N
29	121	TEAM LEADER	18.Jan.17	7:00	18:00	11:00	9:00	2:00		N
30			19.Jan.17						ABSENT	N
31	121	TEAM LEADER	20.Jan.17							H
32
33
34	25			Normal Overtime ----->	39		Holiday Overtime ----->	18

Worksheet: Aftert121


Using Excel 2007 32 bit

Row\Col	B	C	D	E	F	G	H	I	J
34	TOTAL NO. OF DAYS ----->	=30-COUNTIF(K1:K31,"ABSENT")			Normal Overtime ----->	=SUMIF(L1:L31,"N",J1:J31)*24		Holiday Overtime ----->	=SUMIF(L1:L31,"H",J1:J31)*24

Worksheet: After121