Hi everyone,
I need some help on vacation accrual. I'll try to explain as best as I could.
Employees accrue vacation hours on a weekly basis as follows:
( Hiring Date )
0 – 1 years .77 per week for a total of 40 hours of vacation time.
2 – 7 years 1.54 hrs per week for a total of 80 hours of vacation time.
8 – 15 years 2.31 hrs per week for a total of 120 hours of vacation time.
16 – 25 years 3.08 hrs per week for a total of 160 hours of vacation time.
I cannot figure out formulas for this weekly accrual.
Bookmarks