Search:

Type: Posts; User: nelsondavid

Search: Search took 0.01 seconds.

  1. Dear Alan:), Thanks a Lot , it seems to be...

    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:)
  2. Dear Alan:), TOTAL NO. OF DAYS ----->25 ...

    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...
  3. Dear Alan, Files attached again and also in...

    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
  4. Dear Alan, 25 days ABSENT ,i.e, Absent 4 days...

    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...
  5. Dear Alan, Yes i actually forget to tell you...

    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...
  6. Dear Nelson, The code working fine , but have...

    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...
  7. Dear Alan, The code seems to be working...

    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...
  8. Code Required

    Dear Alan,

    As requested two files attached .

    Thanks,

    Nelson:)

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    ...
  9. Code Required to calculate number of days worked, normal overtime and holiday overtime

    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:)
Results 1 to 9 of 9