Dear Friends, I have a problem, just referred to you to solve it for me. In my office rule and regulation every employee entitles monthly "Annual and Sick Leaves" as you see in the attachment. There is a limitation that is not to exceed.
I YELLOWED the place where I need the formula (in the attached file) that is not allow to exceed, for example from 200 hours, while it is exceeded to 232 hours.
By manually no problem we can do it, but I am searching a better way to do it automatically.
How to protect it from exceeding from 200hours? Thank you very much in Advance for your great cooperation
From Italy
6I YELLOWED the place where I need the formula (in the attached file) that is not allow to exceed, for example from 200 hours, while it is exceeded to 232 hours.
By manually no problem we can do it, but I am searching a better way to do it automatically.
How to protect it from exceeding from 200hours? Thank you very much in Advance for your great cooperation
From Italy
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
From India, Hyderabad
Please Find attached the file with the desired function. Please revert back if this fulfil your requirement. Regards. Prafulla Khedkar
From India, Pune
From India, Pune
You may try the attached sheet, if you want the actual result if it is <200. Regards. Praulla Khedkar
From India, Pune
From India, Pune
Dear Parwiz,
You want to check that if the person goes beyond 200 hrs you should come to know, and you can stop him for taking further leaves.
Just go to the col. where hrs are totaled and do conditional formating for higher than 199 it should highlight. As soon as it reaches 200 the cell will highlight.
See if that helps you. Because formula will calculate and put 200, even if that person has taken more than 200 hrs leave.
I think you want to control employees taking more than 200 hours leave.
Please comment.
Gautam Shastry
From India, Visnagar
You want to check that if the person goes beyond 200 hrs you should come to know, and you can stop him for taking further leaves.
Just go to the col. where hrs are totaled and do conditional formating for higher than 199 it should highlight. As soon as it reaches 200 the cell will highlight.
See if that helps you. Because formula will calculate and put 200, even if that person has taken more than 200 hrs leave.
I think you want to control employees taking more than 200 hours leave.
Please comment.
Gautam Shastry
From India, Visnagar
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 problem. If an employee entitles 220 it shows 200, it is perfect, if someone entitles less than 200, it shows error, could you please solve this as well?!
Best Regards,
From Italy
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 problem. If an employee entitles 220 it shows 200, it is perfect, if someone entitles less than 200, it shows error, could you please solve this as well?!
Best Regards,
From Italy
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
From India, Pune
hi all
I AM, WORKING IN A PRIVATE FIRM AND I HAVE TO CREATE A TIME SHEET HERE COZ NO ONE IS TAKING CARE OF THE ATTENDENCE PART ,THAT IS MAKING ME UNEASY TO WORK ,PLEASE FRIENDS HELP ME OUT ,PLEASE IF ANYONE HAS A SIMPLE TIMESHHET MADE PLEASE FORWARD IT TO ME
THANKS AND REGARDS
SATISH KUMBAHR
From India, Vasco Da Gama
I AM, WORKING IN A PRIVATE FIRM AND I HAVE TO CREATE A TIME SHEET HERE COZ NO ONE IS TAKING CARE OF THE ATTENDENCE PART ,THAT IS MAKING ME UNEASY TO WORK ,PLEASE FRIENDS HELP ME OUT ,PLEASE IF ANYONE HAS A SIMPLE TIMESHHET MADE PLEASE FORWARD IT TO ME
THANKS AND REGARDS
SATISH KUMBAHR
From India, Vasco Da Gama
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
The-Winning-for mula.pps
Split the Name - Formula.xls
Attrition Rate formula.pdf