Thanks in advance for any help offered. I'm looking for help creating a formula to accrue PTO as well as track available PTO as it's used. And, not go negative if possible... if an employee reaches 0 PTO, they just take time off without pay, so a negative balance would cause issues with the calculations. Here are the specifics:

Pay periods are from the 1st of the month through the 15th. and the 16th through the end of the month. Each employee receives 3.33 hours of PTO for each pay period. Employees are eligible to START accruing PTO after 6 months of employment.

I found a similar forum post at: http://www.excelforum.com/excel-gene...tion-time.html

That seemed close, however I'm just not efficient enough in Excel to understand exactly what the formulas are doing... specifically the formula for available vacation. I think I have the Rate formula figured out by using: =IF((TODAY()-C2)>160,3.33,IF((TODAY()-C2)<160,0)) However would love someone to check the logic on that one as well and give me their feedback.

Thank you very much for your help folks.