01Free Online Calculator + Excel Workbook
PTO Accrual Calculator: Hours per Pay Period & Balance
Free PTO accrual calculator: hours earned per pay period and per hour worked, balance today and at year end. Excel tracker for the whole team included.
PTO Accrual Calculator
How PTO Accrual Is Calculated
Turn the yearly allowance into hours, then spread it over the pay periods. 15 days at 8 hours is 120 hours a year; on a biweekly payroll that is 120 ÷ 26 = 4.62 hours per paycheck.
| PTO per year | Weekly (52) | Biweekly (26) | Semimonthly (24) | Monthly (12) | Per hour worked |
|---|---|---|---|---|---|
| 10 days (80 h) | 1.54 h | 3.08 h | 3.33 h | 6.67 h | 0.0385 h |
| 15 days (120 h) | 2.31 h | 4.62 h | 5.00 h | 10.00 h | 0.0577 h |
| 20 days (160 h) | 3.08 h | 6.15 h | 6.67 h | 13.33 h | 0.0769 h |
| 25 days (200 h) | 3.85 h | 7.69 h | 8.33 h | 16.67 h | 0.0962 h |
For hourly and part-time staff, accrue per hour worked: divide the annual PTO hours by 2,080 (52 weeks × 40 hours). Balance = carried over + accrued to date − used, limited by the cap if your policy has one.
Policy Choices the Numbers Depend On
- Accrual or front-loading. Accrual earns time each pay period; front-loading grants the whole year on one date. Accrual keeps new hires from using a year of time off in their first month.
- Cap and carryover. A cap stops accrual at a set balance until time is used; a carryover limit decides what moves into the next year. State law decides which of these you may use.
- PTO and paid sick leave. No federal law requires paid vacation. Many states and cities do require paid sick leave, with their own accrual rates and caps. Check the rule for each work location before you set one policy for everyone.
A tracker works until requests, approvals and balances live in three places. In Draivix Leave & Absence Management, an employee requests time off, the supervisor approves it and the balance updates, and the approved absence appears in the same attendance record payroll works from.
Last reviewed: November 18, 2026. This page explains general rules and is not legal advice.
02Frequently Asked Questions
How many PTO hours per pay period is 3 weeks a year?
Three weeks is 15 days, or 120 hours at 8 hours a day. That is 4.62 hours per biweekly pay period, 5.00 hours semimonthly, 10 hours monthly or 2.31 hours weekly.
How do I calculate PTO accrual per hour worked?
Divide the annual PTO hours by 2,080, the hours in a 40-hour work year. 80 hours of PTO is 0.0385 hours per hour worked; 120 hours is 0.0577.
Does PTO accrue on overtime hours?
That depends on your written policy. Many employers accrue on regular hours only, up to 40 a week. Where a state or city paid sick leave law applies, it defines which hours count.
Is PTO required by law in the United States?
No federal law requires paid vacation or PTO. Paid sick leave is required in many states and cities, each with its own accrual rate, so the answer for sick time depends on where the employee works.
03More Free Tools
Related Templates & Calculators
- Timesheet Template: Weekly, Biweekly, Monthly (Excel, PDF)Free timesheet template in Excel and printable PDF: weekly, biweekly and monthly sheets with lunch breaks, automatic hours and overtime after 40 hours.Open
- Employee Schedule Template: Weekly Work Schedule (Excel)Free weekly employee schedule template in Excel and PDF: shifts for 12 employees, hours per person, staff per day and a flag for weeks over 40 hours.Open
- Invoice Template: Free Excel & Printable PDF (US)Free invoice template in Excel and PDF for US businesses: line items, sales tax rate, shipping, Net 30 due date and automatic totals. No sign-up.Open
- Purchase Order Template with 3-Way Match (Excel, PDF)Free purchase order template in Excel and PDF, with a three-way match sheet that compares PO, receipt and supplier invoice and flags lines to hold.Open
Let’s start together
Tell us how your business works.
We will show you what a system that takes over part of that work could look like.
Book a consultation