+ Reply to Thread
Results 1 to 1 of 1

attendance linked to country's holidays and work schedule

  1. #1
    Forum Contributor
    Join Date
    01-16-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    105

    attendance linked to country's holidays and work schedule

    Hi,

    I've been working my time attendance file, it works fine at first. But as I use it for longer periods I see something that is not included in my template- 1)date that is link to the holidays and 2)work schedule.

    What am trying to solve is that once I enter a date in my attendance sheet and that date falls on a holiday (legal or special holiday) the employee who works that day should not be considered as late or absent but rather reflects as overtime work same goes with the work schedule, that if the employee work on a weekend (Saturday or Sunday) which is his rest day, he should not be considered late or absent but an overtime work.

    Does this case "link" in excel be recognized. All I could think is I added a another sheet that is the holiday schedule and sheet for the work schedule. Here's my sample.

    Thank you
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1