Please help with vacation accrual

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.

Just add names and dates as needed.