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
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
1 Attachment(s) [Login To View]