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.
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!
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?!
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