I have a spreadsheet that tracks benefit time at work.
We are allowed to accumulate 40 hours of compensation time after that we have to take it in overtime.
what i need is a formula that quit accumulating at 40 then another that takes the excess each pay period and tracks that.
I have attached a sheet to show what i mean.

Thanks, Jerry.

Attached Files

Benifit Time-2017-1.xlsx (65.0 KB, 13 views)