15
I am trying to set up a PTO (Paid time off) benefit that does the following:
up to 3 years , earn 1 hour per 30 hours worked with maximum of 56 hours for year
After 3 years , earn 1 hour per 26 hours worked with maximum of 80 hours for year
After 7 years , earn 1 hour per 17 hours worked with maximum of 120 hours for year
After 30 years , earn 1 hour per 13 hours worked with maximum of 160 hours for year
Please help
Many thanks.
Jana:
I tried to set it up as you mentioned. Add it is okay for someone to earn .03334 per hour worked , maxing out at 56 hours 1st year , etc. per your chart.
But it does not calculate at all, HELP, is it an hourly thing I am missing.
In the past we gave # of hours per month worked, but wanted to do it based on hours.
Please help or point me in a direction.
Many, many thanks.PTO-hourly-SOlomon-10_2D00_19_2D00_20.docx
You couldn’t set it up exactly as that is worded. As an example, at every 30 hour increment, the employee is awarded 1 hour of PTO. Employee works 30 hours, they get 1 hour PTO. They work another 20 (50 for benefit year) they still have 1 hr PTO. They work another 10 hours (60 in the benefit year), they get a second hour of PTO. They work another 29 (89 in benefit year), they still have 2 hours PTO. Etc.
But you could setup a benefit based on hours worked.
And then setup an hourly rate like 0.0333. If they work 30 hours then, they would get 99.9999 hours of PTO. The benefit awarded rounds to 2 decimals so that would be 1.00 PTO hours for 30 hours worked. But it wouldn’t trigger 1 hour of PTO every 30 incremental hours. It would award 0.3334 hours for every hour worked. An employee that worked 20 hours would get 0.67 hours of PTO awarded. An employee that worked 110 hours would be awarded 3.67 hours, etc.
As long as they are OK with it being awarded for every hour worked, the table would look something like this:
If this is confusing , you might open a support case to have someone look at this with you.
Best Regards
Jana MacDonald
MSFT Support
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
