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

[DocAElstein]

Hi Nelson

Files attached again and also in column K absent days should be marked as ABSENT..

This is a new requirement ?

But I understand and can do it

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

_1)

....Rest all seems to be fine...

No rest is still NOT fine

I count 24 days in Worksheet "121" ( "File 3 Before.xlsx" = 24 days worked)

You give 25 ????

Please explain why you give 25 ????



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

_2)
The test data that you have chosen does not test this scenario “...holiday is deducted if the person does not come the day before and after the holiday...”


Let me try to explain to you what you possibly want ( = ..holiday is deducted if the person does not come the day before and after the holiday... )

If Before =

Row\Col	E	F	G	H	I	J
9	29.Dec.16
10	30.Dec.16	7:00	18:00	11:00	9:00	2:00
11	31.Dec.16

Worksheet: 121Before

Then After =

Row\Col	E	F	G	H	I	J
9	29.Dec.16
10	30.Dec.16	7:00	18:00	11:00	9:00	2:00
11	31.Dec.16

Worksheet: 121After

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

Else IF Before =

Row\Col	E	F	G	H	I	J
9	29.Dec.16	7:00	18:00	11:00	9:00	2:00
10	30.Dec.16	7:00	18:00	11:00	9:00	2:00
11	31.Dec.16

Worksheet: 121Before

Then After =

Row\Col	E	F	G	H	I	J
9	29.Dec.16	7:00	18:00	11:00	9:00	2:00
10	30.Dec.16	7:00	18:00	11:00		10:00
11	31.Dec.16

Worksheet: 121After

Is this correct?





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

Try again !!!

.....
You must make sure that your test data in Before and After illustrates all possible scenarios( and that it is correct ! )
...

Alan

P.s. I have had a code for you finished now for many days: But I cannot test it until you give me correct info and data !!!!!!
I am very confused, why you keep giving me wrong and inappropriate data ????


P.P.s. You are using the second code. It uses the formulas suggested by Admin. It need a help column which the code puts in. It did put those in column K. But you want that for the ABSENT indication. So I suggested that could be in column L. I had no response and I do not know why am writing this as I expect you have no idea what I am saying. Never mind. I expect we will get there in the end.