I am currently looking to create a spreadsheet that will track PTO for our employees (currently around 140). They are paid weekly and the following is our accrual schedule based off number of hours accrued per week.

0-1 years .5 hours weekly
1-2 years 1.3 hours weekly
2-3 years 1.4 hours weekly

3-5 years 1.7 hours weekly

6-8 years 2.2 hours weekly

9-10 years 3.1 hours weekly

10+ years 4.7 hours weekly

Calculation is based on start date and they can carry over up to 10 days of PTO time. Anything over that 10 days will automatically be cashed out.

Thank you for any assistance in building this.