This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have attached a sample file with attendance data that I am analyzing. I want to update the attendance type field in cases where an employee has taken a Leave Without Pay (LWP) or Leave of Absence before and after a weekend/weekly-off/holiday.
The rule is that if an employee's attendance is:
then the days between the LWPs/Absent days need to be converted to Absent. Unless there is an absent or a LWP on either side of the holidays/days off, there is no sandwiching. This is the rule for "sandwiching" of leaves.
The days of weekly-offs and holidays are not fixed for all employees. Also, it is not necessary that weekly-offs will be on consecutive days.
Could someone please advise me on how I should approach this step of my analysis?
For clarification, could you add a column to the file you attached which shows what the attendence type would be ammended to read based on the rules (if it changes at all which it doesn't in most cases!).
That would help us know exactly what you are looking for.