Finance | Project Operations, Human Resources, ...

Benefit to add 1 hr of PTO (a benefit) for every 30 hours someone works

(0) Share

Report

Posted on by Rhoch

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.

All responses (2)

Answers (0)

Rhoch 15 on at

Like (0)

Report

RE: Benefit to add 1 hr of PTO (a benefit) for every 30 hours someone works

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
Suggested answer

CFROTON 4,710 on at

Like (0)

Report

RE: Benefit to add 1 hr of PTO (a benefit) for every 30 hours someone works

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