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

[DocAElstein]

After from running code (HTML) :
Sub IJAdjust_LAdd_AbsentKAdd_TotalsFormulas_AllWorkshe etsCode4()



Excel 2007 32 bit

	D	E	F	G	H	I	J	K	L
1	TEAM LEADER	21.Dec.16	7:00	18:00	11:00	9:00	2:00		N
2	TEAM LEADER	22.Dec.16	7:00	18:00	11:00	9:00	2:00		N
3	TEAM LEADER	23.Dec.16	7:00	15:00	8:00		8:00		H
4	TEAM LEADER	24.Dec.16	7:00	18:00	11:00	9:00	2:00		N
5	TEAM LEADER	25.Dec.16	7:00	18:00	11:00	9:00	2:00		N
6	TEAM LEADER	26.Dec.16	7:00	18:00	11:00	9:00	2:00		N
7	TEAM LEADER	27.Dec.16	7:00	17:00	10:00	9:00	1:00		N
8	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	TEAM LEADER	1.Jan.17	7:00	18:00	11:00	9:00	2:00		N
13	TEAM LEADER	2.Jan.17	7:00	18:00	11:00	9:00	2:00		N
14	TEAM LEADER	3.Jan.17	7:00	18:00	11:00	9:00	2:00		N
15	TEAM LEADER	4.Jan.17	7:00	18:00	11:00	9:00	2:00		N
16	TEAM LEADER	5.Jan.17	7:00	18:00	11:00	9:00	2:00		N
17	TEAM LEADER	6.Jan.17							H
18	TEAM LEADER	7.Jan.17	7:00	18:00	11:00	9:00	2:00		N
19	TEAM LEADER	8.Jan.17	7:00	18:00	11:00	9:00	2:00		N
20	TEAM LEADER	9.Jan.17						ABSENT	N
21	TEAM LEADER	10.Jan.17	7:00	18:00	11:00	9:00	2:00		N
22	TEAM LEADER	11.Jan.17	7:00	18:00	11:00	9:00	2:00		N
23	TEAM LEADER	12.Jan.17	7:00	18:00	11:00	9:00	2:00		N
24	TEAM LEADER	13.Jan.17	7:00	18:00	11:00		10:00		H
25	TEAM LEADER	14.Jan.17	7:30	17:30	10:00	9:00	1:00		N
26	TEAM LEADER	15.Jan.17	7:30	17:30	10:00	9:00	1:00		N
27	TEAM LEADER	16.Jan.17	7:30	17:30	10:00	9:00	1:00		N
28	TEAM LEADER	17.Jan.17	7:30	17:30	10:00	9:00	1:00		N
29	TEAM LEADER	18.Jan.17	7:00	18:00	11:00	9:00	2:00		N
30		19.Jan.17						ABSENT	N
31	TEAM LEADER	20.Jan.17							H

After121

[DocAElstein]

Totals output for last post ( HTML )

Excel 2007 32 bit

	B	C	D	E	F	G	H	I	J
34	TOTAL NO. OF DAYS  ----->	25			Normal Overtime  ----->	39		Holiday Overtime  ----->	18

After121

Worksheet Formulas Cell Formula C34 =30-COUNTIF(K1:K31,"ABSENT") G34 =SUMIF(L1:L31,"N",J1:J31)*24 J34 =SUMIF(L1:L31,"H",J1:J31)*24

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://eileenslounge.com/viewtopic.php?p=326972#p326972
https://eileenslounge.com/viewtopic.php?p=326853#p326853
https://eileenslounge.com/viewtopic.php?p=326446#p326446
https://eileenslounge.com/viewtopic.php?f=27&t=41986
https://eileenslounge.com/viewtopic.php?p=325610#p325610
https://eileenslounge.com/viewtopic.php?p=325609#p325609
https://eileenslounge.com/viewtopic.php?p=325605#p325605
https://eileenslounge.com/viewtopic.php?p=325548#p325548
https://eileenslounge.com/viewtopic.php?p=316441#p316441
https://eileenslounge.com/viewtopic.php?p=324736#p324736
https://eileenslounge.com/viewtopic.php?p=324990#p324990
https://eileenslounge.com/viewtopic.php?f=27&t=41937&p=325485#p325485
https://eileenslounge.com/viewtopic.php?p=325609#p325609
https://eileenslounge.com/viewtopic.php?p=325610#p325610
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA