Calculate the hourly PTO accrual rate
Use PTO earned = eligible hours × accrual rate. If the policy expresses an annual allowance instead, divide annual PTO hours by annual eligible hours to derive an hourly rate. An example allowance of 80 hours over 2,080 eligible hours gives 80 ÷ 2,080 = 0.038461538… PTO hours per eligible hour.
The 2,080 figure comes from 40 × 52. It is an example denominator, not a rule for every employee. A 37.5-hour schedule, a different eligibility definition or a part-year arrangement may require a different denominator. Do not reduce both the allowance and denominator without checking how the policy defines the rate.
Work through variable hours across three periods
| Period | Eligible hours | Earned PTO, six decimals |
|---|---|---|
| 1 | 72 | 2.769231 |
| 2 | 80 | 3.076923 |
| 3 | 64 | 2.461538 |
| Total | 216 | 8.307692 |
At the same rate, more eligible hours earn more PTO. A fixed award per paycheck behaves differently: 80 ÷ 26 gives approximately 3.076923 hours each eligible biweekly period, regardless of the different period hours in this example. Do not switch between these methods to force a payslip match.
Build a PTO accrual worksheet in Excel
Use this layout for a constant hourly rate, before caps and leave usage:
- Enter annual PTO hours, 80, in F2 and annual eligible hours, 2080, in F3.
- Enter period labels in A2:A4 and eligible hours 72, 80, 64 in B2:B4.
- In C2 enter
=B2*$F$2/$F$3and fill down through C4. - In B5 enter
=SUM(B2:B4). In C5 enter=SUM(C2:C4).
C5 should be approximately 8.307692 hours. Format the cells to show the precision you need without altering the underlying values. If the policy rounds each earning transaction to hundredths, use =ROUND(B2*$F$2/$F$3,2) for each period instead. That produces 2.77 + 3.08 + 2.46 = 8.31 hours here. Other inputs can create a different total than rounding only once.
Check eligibility, rate changes and the final balance
Before calculating, identify whether the policy includes holidays, paid leave or overtime hours. Ten eligible overtime hours are ten hours for an hours-based formula unless the policy expressly applies a different weighting; a pay multiplier is not automatically an accrual multiplier.
If the rate changes during a period, split the eligible hours at the effective date. For example, 40 hours at 0.04 plus 32 hours at 0.06 earns 1.60 + 1.92 = 3.52 PTO hours. Applying the new rate to all 72 hours would instead produce 4.32, overstating this example by 0.80 hours.
Then reconcile the balance separately: opening balance + credited accrual − leave used + adjustments. An opening 12 hours, 8.31 credited hours and 6 used hours gives 14.31 hours before caps or further adjustments. A cap may make transaction dates important; use the dated PTO balance ledger for that check.
Frequently asked questions
How much PTO is earned for 40 hours worked?
Multiply 40 by the policy's hourly rate. At 80 ÷ 2,080, the result is about 1.538462 hours before rounding. There is no universal accrual rate.
Why is earned PTO different from available PTO?
Available PTO also reflects previous balances, usage, adjustments and policy limits. Some systems show booked leave separately from leave already taken.
What should I check if my payslip differs?
Compare eligible hours, the effective rate, the posting date and the rounding step. Reconcile those inputs before assuming the arithmetic or payroll record is wrong.
Use the PTO accrual calculator for your figures, then read PTO accrual explained for the wider balance workflow.