Excel PTO Accrual

I have searched high and low for excel spreadsheets to match what I am looking for and I have found one. The conversation for that post however has been closed, and so whomever made this spreadsheet I THANK YOU. HOWEVER, I have been racking my brain trying to figure out what I am doing wrong.

PTO Accrues 1 day per 30 hours worked.
However if an employee works 36 hours it doesn't calculate that extra PTO day after the 6's add up.
I also realized my sheet doesn't calculate an extra day if an employee works 60 hours in a week.

I apologize if it is against the rules to use someone else's spreadsheet, and I apologize if I have broken any rules. I have noooo idea what I am doing.

Just need a little help.


Thank you so much!!!!!