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

[DocAElstein]

The code working fine , but have two problems 1)It calculates the number of days worked as 30 even if the person absent for one or two days...

Hi Nelson
I have 5 questions ( _1a) 1b) 2a) 2b) 3) ) for you:
_1) you told me that days are always 30 ??
_1a) How do you now want Days calculated? ?????

( This is a new requirement I expect? Your original Before had no entries in column
_1b) Is the requirement for taking into account absence new? ( or did you forget it originally) ?? )



_2a) Which code are you using ?????
( You have 2

.......
P.s.
We have given you 2 codes
From Alan
Post #19 here: http://www.excelfox.com/forum/showth...age2#post10066

From Alan and Admin
Post #20 here: http://www.excelfox.com/forum/showth...age2#post10072

Which are you using? Which do you prefer?? ????

_2b) Which do you prefer?? ????



-3) Are you sure that you do not require a header row ???
Do you require a header row as in your first post here: File Sample2.xlxs http://www.excelfox.com/forum/showth...0058#post10058

Header.jpg http://imgur.com/1Dvfv6N
Header.JPG




Alan