My employer is changing the way our vacation works. Instead of getting your vacation (based on years worked) at the start of each year, we are to accrue it on a monthly basis. My accrual would be 13.34 hours per month. We are allowed to borrow up to 40 hours against our potential future accruals but the balance must reflect the "red" and then come back into the black when it's "paid back". I am not good enough at Excel to put together fancy formulas. Can anyone help me fashion a spreadsheet to keep track of my vaca?
Thanks so much.