I am dyin' here...
I've attached a sample sheet I started 4 hours ago...need to calculate how much time everyone has in sick and vacation time. Don't believe they want it to go back to their start date. Simply calculate for the year but WHATEVER...just want to get it DONE!!!
Here are the parameters
Policy for Sick Time:
Reg FT employees accrue sick leave at the rate of 5 days per year (.41666 days per month).
Leave is used at a minimum of 4 hours
Vacation policy:
- employees working here under 10 years earn up to a max of 10 vacation days a year accrued at a rate of .8334 days per month
- after 5 years employees earn up to a max of 15 vacation days each year accrued monthly at the rate of 10 hours per month
- After 10 years the employee may earn up to a max of 20 vacation days each year, accrued monthly at the rate of 13.3334 hours per month
Thanks to anyone who can help me with this!!!
Bookmarks