I know this has been discussed in previous posts, but every PTO policy is different.
I'm putting together a spreadsheet for a start-up client of mine. The would like to see every employee's current PTO balance (approx. 20 people). Employees begin accruing time immediately upon date of hire and earn 4 hours of PTO every pay period (they're paid semi-monthly), for a max of 96 hours per year. I would like to determine their exact amount based on their start date, and how much they've taken.
I can't imagine the formula would be that involved, but would like to have it set up like the attached spreadsheet.
Thanks in advance!
Bookmarks