PTO Calculation.xlsI am making a spreadsheet that calculates PTO for employees. Employees with 0-5 yrs get 2.308 hours a week up to 120 hrs/year. Employees with 5+ yrs get 3.077 hours a week up to 160 hrs/year. I am attaching the setup that I would like to use. I came up with a formula that works except for 1 problem:
If the employee reached their 5 yr mark during the year,such as employee #2 does in the attachment, how can I formulate 2.308hrs/week up until they reach their 5yr mark and then do 3.077hrs/week from then on out?
Bookmarks