Accrual Cap Paid Time Off Function Help Needed

I have a cell that needed to keep a running total of the current balance of Paid Time Off, where F5=Beginning balance of hours F6=Accrued Hours (goes up at a steady rate every 2 weeks), F7=Total hours taken off (goes up whenever an entry is made) and F8= The Cap/Max Amount of hours
F9 could equal total current balance (F5+F6-F7).

The displayed amount needed to ignore or simulate ignoring any hours over the cap earned by accrual, but go down from the cap when ANY additional hours taken off, and then allow accruals again once its down below the cap.

Any functions I've made have pulled new hours taken off from a running total of everything, higher than the cap. So if there's technically 60 hours available to an employee and the cap is 50, if they take 5 hours off, it still just shows the cap. Help greatly appreciated, thank you!

UPDATE:

The way it's looking to me, the formula will need to know what order time off was taken in. For instance, when there is a cap of 60:
Scenario 1
Event 1: 50 hours opening balance
Event2: 20 hours accrued
Event 3: 25 hours taken
The ending balance is: 35 (60-25)

Scenario 2
Event 1: 50 hours opening balance
Event 2: 25 hours taken
Event 3: 20 hours accrued
ENding balance: 45 (50-25+20)

Sime time off is taken randomly disperse throughout the static growth of the earned time, it seems its going to get impossible or extremely complicated. Is there a better way to do with, multiple formulas?



-Brant