Notes tests. Excel VBA Folder File Search

[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