Hello everyone with respect,
I am Rajesh Kumar, Senior Executive - HR. I want a formula in 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.
With regards,
Rajesh Kumar
MB - 9582299828
From India, Gurgaon
Acknowledge(0)
Amend(0)
I am Rajesh Kumar, Senior Executive - HR. I want a formula in 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.
With regards,
Rajesh Kumar
MB - 9582299828
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)
Rajesh, you can do this in Excel; however, it is difficult to manage these things in Excel for a long period of time. The other challenge is that Excel data is not transparent to the employee, so you'd keep getting a lot of queries regarding the leave deduction.
You should take a look at some automated leave and attendance management system which can be extended with ESS so your manual work is reduced and the process is also transparent. Our company and many others provide such solutions. I'll be happy to provide more details on this if you wish.
From India, Chennai
Acknowledge(0)Amend(0)
You should take a look at some automated leave and attendance management system which can be extended with ESS so your manual work is reduced and the process is also transparent. Our company and many others provide such solutions. I'll be happy to provide more details on this if you wish.
From India, Chennai
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Performance Management System.doc