Dear Alan:),
Thanks a Lot , it seems to be working fine..if find any problem will get in touch with you
Thanks and appreciate your patience to solve the problem
Nelson:)
Type: Posts; User: nelsondavid
Dear Alan:),
Thanks a Lot , it seems to be working fine..if find any problem will get in touch with you
Thanks and appreciate your patience to solve the problem
Nelson:)
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...
Dear Alan,
Files attached again and also in column K absent days should be marked as ABSENT
Rest all seems to be fine
Thanks,
Nelson
Dear Alan,
25 days ABSENT ,i.e, Absent 4 days plus one holiday (4 days) -29,31,9,19 and 30 (the employee did not come on 29 and 31 so 30 holiday marked as absent)
If Question 2 scenario arises...
Dear Alan,
Yes i actually forget to tell you about the absent days.What i mean "Every month we consider of 30 days , if the month is of 30 or 31 or like 28 days Feb all these months we take it as...
Dear Nelson,
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
2)I use column K for remarks which you...
Dear Alan,
The code seems to be working fine:)..i need normal OT and Holiday OT to appear exactly in cell G34 and J34
Can i use the same code for every month and if yes what changes i need to do...
Dear Alan,
As requested two files attached .
Thanks,
Nelson:)
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
...
Hi,
I require a code which i can run though to calculate number of days worked, normal overtime and holiday overtime for all sheets in the workbook
Sample file attached
Thanks
Nelson:)