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

[nelsondavid]

Dear Alan,

TOTAL NO. OF DAYS ----->25 ,i.e, Absent 4 days plus one holiday (5 days) - Absent days are 29,31,9,19 and 30 (the employee did not come on 29 and 31 so 30 holiday marked as absent).......

Rest explained in attached file

Thanks,

Nelson

[DocAElstein]

Hi Nelson,

...(the employee did not come on 29 and 31 so 30 holiday marked as absent)......

This I now understand ( It was impossible to know this as the code was not putting ABSENT in. I can do this and understand now

Using Excel 2007 32 bit
BEFORE







29.Dec.16







30.Dec.16







31.Dec.16































AFTER







29.Dec.16





ABSENT

30.Dec.16





ABSENT

31.Dec.16





ABSENT


Worksheet: Sheet1

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

...
TOTAL NO. OF DAYS ----->25 ,i.e, Absent 4 days plus one holiday (5 days) - Absent days are 29,31,9,19 and 30 (the employee did not come on 29 and 31 so 30 holiday marked as absent)....

OK This makes sense now
( You forgot to put ABSENT in 30. December , ( "File 4 After.xlsx" )
This was your After ( "File 4 After.xlsx" )

29.Dec.16						ABSENT
30.Dec.16
31.Dec.16						ABSENT

Worksheet: 121

It should have been this !!!

29.Dec.16						ABSENT
30.Dec.16						ABSENT
31.Dec.16						ABSENT

Worksheet: 121
_............................

I think I understand now
I will have time to look again at this tomorrow



Alan