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

[DocAElstein]

..... you can add one more column at the end to highlight which is the normal working day or holiday rather than coloring the cell......

Hi Admin
I was a bit confused at first.
I see now what you have done now.
You have taken his AFTER and applied a SUMIF on the two columns I and J....

So first , You added then the extra column K with H for Holiday and N for normal day,
After Worksheet

Row\Col	E	F	G	H	I	J	K
1	21.Dec.16	7:00	18:00	11:00	9:00	2:00	N
2	22.Dec.16	7:00	18:00	11:00	9:00	2:00	N
3	23.Dec.16	7:00	15:00	8:00		8:00	H
4	24.Dec.16	7:00	18:00	11:00	9:00	2:00	N
5	25.Dec.16	7:00	18:00	11:00	9:00	2:00	N

Worksheet: 121

Then you have these formulas:

Row\Col	G	H	I	J
35	=SUMIF(K1:K31,"N",J1:J31)			=SUMIF(K1:K31,"H",J1:J31)

If Nelson wanted to do that he would still need to use part of my code to get the AFTER worksheet in its final form, as his start point , the BEFORE File is a bit different and needs a bit of manipulation based on his various criteria. ( Columns I and J needed to be adjsued:
BEFORE

Row\Col	E	F	G	H	I	J
1	21.Dec.16	7:00	18:00	11:00	9:00	2:00
2	22.Dec.16	7:00	18:00	11:00	9:00	2:00
3	23.Dec.16	7:00	15:00	8:00	9:00	0:00
4	24.Dec.16	7:00	18:00	11:00	9:00	2:00
5	25.Dec.16	7:00	18:00	11:00	9:00	2:00

Worksheet: 121

_...........

By the way, I originally assumed that Holiday was a “Holy Friday thing”, ( So I was checking in my code for Friday and not yellow background color )but I am not sure if that is correct.
What I will do in the next posts to cover my back and to let your solution work is do another code, which checks based on the background colour being yellow for a holiday, then does the manipulation of the Worksheet, but also then after that includes your “H” or “N” in col.umn K, and while I am at it I will pastes in your formulas:

I expect then Nelson will have more than enough to keep him busy or confuse him

Alan