When PTO accrues from eligible hours worked, a variable schedule produces variable credits. Forecast each period's eligible hours and multiply by the accrual rate. A fixed monthly credit is unsuitable unless it is how the policy actually works. Use a range when future shifts are uncertain.
Start with the eligible-hours definition
Identify which recorded hours earn PTO. Work, paid leave, training and other time codes may be treated differently. This page uses hypothetical eligible hours and does not assume every paid hour qualifies. If the policy sets a maximum number of accruing hours per period, apply that limit before multiplying by the rate.
Suppose the accrual rate is 0.04 PTO hours per eligible hour. Four upcoming weeks are expected to contain 24, 32, 28 and 36 eligible hours. The total is 120 hours and expected accrual is 4.8 PTO hours.
| Week | Eligible hours | Calculated PTO |
|---|---|---|
| 1 | 24 | 0.96 |
| 2 | 32 | 1.28 |
| 3 | 28 | 1.12 |
| 4 | 36 | 1.44 |
| Total | 120 | 4.80 |
Use scenarios when shifts are not confirmed
If the four-week total could range from 96 to 144 eligible hours, expected accrual ranges from 3.84 to 5.76 hours. Show that range alongside the central 4.8-hour estimate. It exposes how much of the leave plan depends on shifts that have not been assigned.
Starting from 20 hours and planning 24 hours of leave, the projected ending balance is −0.16 under the low-hours scenario, 0.8 under the expected scenario and 1.76 under the high-hours scenario. Those figures assume all credits arrive before the leave and that there are no caps or other transactions. A positive expected result is not the same as a guaranteed sufficient balance.
Put credit dates on the forecast
Hours worked and PTO credited can occur on different dates. If the fourth week's credit posts after the leave begins, exclude it from the departure-date balance. Keep a date column for both the work period and the credit event when timing matters.
Apply the policy's rounding at its actual stage. Rounding each weekly estimate when the employer rounds only the pay-period credit introduces an artificial difference. Retain the unrounded calculation in the planning sheet for reconciliation.
Update estimates with actual hours
Replace completed weeks with actual eligible hours while leaving future weeks as estimates. Label the two clearly. When a projection changes, the reader should be able to tell whether the change came from newly assigned shifts, a rate correction or a posted adjustment.
If schedules are highly irregular, avoid treating one unusually busy week as the permanent baseline. Use confirmed future assignments where available, then state the assumptions used for unassigned periods.
Frequently asked questions
Can I use my average weekly hours?
For an early estimate, yes, if the rate and eligibility rules remain stable. For a near-term leave decision, dated hours and posting events are more informative.
What if my balance cap is reached?
Calculated accrual and credited accrual may differ. Run the forecast as a dated ledger and apply the cap rather than adding all theoretical credits at the end.
Related calculators and guides
- PTO Accrual Calculator by Hours Worked or Pay Period
- PTO Goal Date Calculator
- Calculate PTO Accrual from Hours Worked
Explore more in PTO Calculators and Guides.