First Time to post and have been searching the different posts already done trying to find the answers but nothing seems to "FIT"

Attached is the worksheet I am trying to create in my position at work. I have everything figured out except being able to calculate the current hours earned. (Highlighted in Yellow at the top)

Everything is based on Hire Date. The employee earns so many hours of PTO time after each payday. We pay our employees the 15th and the end of the month so a total of 24 pay periods per year. They are able to roll over 40 hours from previous year.

They earn 120 Hours or 15 days up to the first year. 136 Hours or 17 days for years 1-3; 176 Hours or 22 Days for 4-9 years; and 216 Hours or 27 days for years 10+. They are able to take 4 hours or 8 hours off.

Can someone please assist me ? I don't know if I should use a VLOOKUP or just a few formulas.

Thank You Attend.xlsx