I am Rajesh Kumar, Senior Executive - HR. I want a formula in an Excel sheet with two conditions. I hope my query is very small to all of you. Please help me. I am working on an employee attendance sheet in Excel.
Regards,
Rajesh Kumar
[Phone Number Removed For Privacy Reasons]
From India, Gurgaon
Acknowledge(0)
Amend(0)
Regards,
Rajesh Kumar
[Phone Number Removed For Privacy Reasons]
From India, Gurgaon
Acknowledge(0)Amend(0)
I Rajesh, yes i explain for some thing better, my purpose is i working on employee attendance sheet daily update .so i need this formula to calculate the same
From India, Gurgaon
Acknowledge(0)Amend(0)
From India, Gurgaon
Acknowledge(0)Amend(0)
Dear Rajesh,
If I understand correctly, your attendance policy dictates that a WO cannot be taken between two absences. If one is absent on either side of a WO, they will be marked absent for that WO as well.
If so, please find attached an Excel sheet with a macro that will tabulate the same for you. All you need to do is enter the data in the format and click on the button in the top-left corner.
From India, Mumbai
Acknowledge(0)Amend(0)
10If I understand correctly, your attendance policy dictates that a WO cannot be taken between two absences. If one is absent on either side of a WO, they will be marked absent for that WO as well.
If so, please find attached an Excel sheet with a macro that will tabulate the same for you. All you need to do is enter the data in the format and click on the button in the top-left corner.
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Attendance sheet.xls