• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Logic Required


New Member

Looking to create a report to bring the output in the format available in "sheet 2"

1. If the swiped hrs is greater than 0, then it should be considered work from office. otherwise, work from home.
2. If C column says "holiday or leave" with total hrs (swiped+WFH hrs) is 0, then it should be considered as leave.
3. Few members apply for holiday but work on these days, it could be either work from office or home. Logic required similar to point 1.

Thank you in advance.


  • attendance.xlsx
    9.7 KB · Views: 3