Dear Friends,
I have a problem and I am reaching out to you to help me solve it. In my office's rules and regulations, every employee is entitled to monthly "Annual and Sick Leaves" as shown in the attachment. There is a limitation that should not be exceeded. I have highlighted the area in the attachment where I need the formula that restricts exceeding the limit. For example, when the allocated hours are 200 and it goes beyond to 232 hours.
While we can currently manage this manually, I am looking for a more efficient way to handle this automatically. How can we prevent it from exceeding 200 hours? Thank you very much in advance for your cooperation.
Best regards
From Italy
Acknowledge(0)
Amend(0)
6I have a problem and I am reaching out to you to help me solve it. In my office's rules and regulations, every employee is entitled to monthly "Annual and Sick Leaves" as shown in the attachment. There is a limitation that should not be exceeded. I have highlighted the area in the attachment where I need the formula that restricts exceeding the limit. For example, when the allocated hours are 200 and it goes beyond to 232 hours.
While we can currently manage this manually, I am looking for a more efficient way to handle this automatically. How can we prevent it from exceeding 200 hours? Thank you very much in advance for your cooperation.
Best regards
From Italy
Acknowledge(0)Amend(0)
Dear Parwiz, Please let me know what exactly you want. I am not able to understand Your requirement. Give some clarity on your expectation. Regards Ganeshan Madhavi
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Please Find attached the file with the desired function. Please revert back if this fulfil your requirement. Regards. Prafulla Khedkar
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
You may try the attached sheet, if you want the actual result if it is <200. Regards. Praulla Khedkar
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
Dear Parwiz,
You want to check if the person exceeds 200 hours so that you can be informed and prevent them from taking additional leave. Simply navigate to the column where the hours are totaled and apply conditional formatting for values higher than 199 to highlight them. Once it reaches 200, the cell will automatically highlight. This method could assist you as the formula may show 200 even if the individual has taken more leave hours.
It appears you aim to manage employees who exceed 200 hours of leave. Your thoughts on this matter are appreciated.
Gautam Shastry
From India, Visnagar
Acknowledge(0)Amend(0)
You want to check if the person exceeds 200 hours so that you can be informed and prevent them from taking additional leave. Simply navigate to the column where the hours are totaled and apply conditional formatting for values higher than 199 to highlight them. Once it reaches 200, the cell will automatically highlight. This method could assist you as the formula may show 200 even if the individual has taken more leave hours.
It appears you aim to manage employees who exceed 200 hours of leave. Your thoughts on this matter are appreciated.
Gautam Shastry
From India, Visnagar
Acknowledge(0)Amend(0)
Dear Gautam Shastry,
Many thanks for the great and kind comment! Yes, I want to control the staff leave not to earn more than 200 hours, just following the organization rule!
Dears,
The formula has a problem. If an employee is entitled to 220 hours, it shows 200; it is perfect. However, if someone is entitled to less than 200 hours, it shows an error. Could you please solve this as well?!
Best Regards,
From Italy
Acknowledge(0)Amend(0)
Many thanks for the great and kind comment! Yes, I want to control the staff leave not to earn more than 200 hours, just following the organization rule!
Dears,
The formula has a problem. If an employee is entitled to 220 hours, it shows 200; it is perfect. However, if someone is entitled to less than 200 hours, it shows an error. Could you please solve this as well?!
Best Regards,
From Italy
Acknowledge(0)Amend(0)
Dear Parwiz, Please refer my second file (........ corrected1.xls). You will get the desired result if less than 200 actual result & if more than 200 result will be 200. Regards. Prafulla Khedkar
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
Hi all,
I am working in a private firm, and I have to create a timesheet here because no one is taking care of the attendance part. That is making me uneasy to work. Please, friends, help me out. If anyone has a simple timesheet made, please forward it to me.
Thanks and regards,
Satish Kumbahr
From India, Vasco Da Gama
Acknowledge(0)Amend(0)
I am working in a private firm, and I have to create a timesheet here because no one is taking care of the attendance part. That is making me uneasy to work. Please, friends, help me out. If anyone has a simple timesheet made, please forward it to me.
Thanks and regards,
Satish Kumbahr
From India, Vasco Da Gama
Acknowledge(0)Amend(0)
Dear Seniors,
I am working at a software company, and I have to create a timesheet in Excel for employees. This timesheet should include details such as time in, time out, daily hours, overtime, breaks, etc.
Could you please provide me with a timesheet template in Excel for employees?
Thank you.
From India, Mumbai
Acknowledge(0)Amend(0)
I am working at a software company, and I have to create a timesheet in Excel for employees. This timesheet should include details such as time in, time out, daily hours, overtime, breaks, etc.
Could you please provide me with a timesheet template in Excel for employees?
Thank you.
From India, Mumbai
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.