Calculate your accrued Paid Time Off (PTO) hours instantly. Supports hourly, weekly, bi-weekly, and monthly accrual cycles.
Paid Time Off (PTO) accruals determine how much vacation or sick leave an employee earns as they complete their work cycles. Employers typically calculate accruals using one of two primary methods: hourly accrual or per-period accrual.
To automatically calculate accumulated PTO in Excel or Google Sheets, use this standard formula where Cell A1 contains total hours worked (or pay periods) and Cell B1 contains your company's accrual multiplier:
=A1 * B1
Tip: To convert total accrued hours into standard days, divide the result by your workday length (typically 8 hours): =(A1 * B1) / 8.
In the United States, there is no federal mandate under the **Fair Labor Standards Act (FLSA)** requiring employers to offer paid vacation, sick leave, or Paid Time Off (PTO). However, if an employer chooses to offer a PTO policy, it must be administered consistently to comply with state-level labor guidelines. Certain states (such as California and New York) have strict legal mandates regarding paid sick leave accrual minimums (such as earning at least 1 hour of paid sick leave for every 30 hours worked, which equals an accrual rate of **0.0333**).
This table displays the standard hourly and bi-weekly accrual rates required to achieve common annual PTO allowances (based on a standard full-time 40-hour workweek, 2,080 hours per year, and 26 pay periods):
| Annual PTO Allowance | Accrual Rate Per Hour Worked | Accrual Rate Per Bi-Weekly Pay Period |
|---|---|---|
| 5 Days (40 hours) | 0.0192 hours | 1.54 hours |
| 10 Days (80 hours) | 0.0385 hours | 3.08 hours |
| 15 Days (120 hours) | 0.0577 hours | 4.62 hours |
| 20 Days (160 hours) | 0.0769 hours | 6.15 hours |
| 25 Days (200 hours) | 0.0962 hours | 7.69 hours |
Quick answers to common questions about calculating Paid Time Off (PTO) accruals.
To calculate accrued PTO, multiply your total hours worked (or pay periods completed) by your standard company accrual rate. For example, if you worked 80 hours in a bi-weekly pay cycle and your hourly accrual rate is 0.0385: 80 × 0.0385 = 3.08 hours of PTO accrued.
For a full-time employee working a standard 40-hour workweek (2,080 hours per year) who receives 10 days (80 hours) of PTO annually, the hourly accrual rate is exactly 0.0385. This is calculated as: 80 hours ÷ 2,080 yearly work hours = 0.03846 hours of PTO earned per hour worked.
For standard full-time employment based on an 8-hour workday, 2 weeks of vacation represents exactly 80 hours of Paid Time Off (10 working days × 8 hours = 80 hours).
To calculate accrued PTO in Microsoft Excel or Google Sheets, use the formula: =A1 * B1 (where A1 represents your hours worked or pay periods, and B1 represents your specific accrual rate). To convert those accrued hours into vacation days, divide by your workday length: =(A1 * B1) / 8.
All the time conversion tools you need, completely free.
Convert hours and minutes to decimal format for payroll and timesheets.
Convert decimal hours back to hours and minutes format (HH:MM).
Convert any decimal time like 7.75 back to hours and minutes instantly.
Add multiple time entries and get total decimal hours for the week.
Calculate gross pay by multiplying decimal hours by your hourly rate.
Full reference chart — every minute from 1 to 60 in decimal format.
Calculate total hours worked between start/end times with break deduction.
Multiply hours, minutes, and seconds by any multiplier factor instantly.
Convert total hours into standard calendar days or business workdays.
Estimate the cash payout value of your accrued, unused vacation days.
Calculate Paid Time Off (PTO) accruals per hour worked or per pay period.
Estimate game and file download times based on size and internet speed.
Convert simple fractions and mixed numbers to decimal format instantly.
Calculate calendar days, business days, and working hours between two dates.
Calculate overtime pay and estimate tax savings under tax-free policies.
Calculate daily regular, overtime (1.5x), and double-time (2.0x) pay.
Calculate your base pay or annual salary after a percentage or flat rate raise.
Calculate regular, overtime (1.5x), and double-time (2.0x) hourly wages.
Find out how standard and supplemental taxes impact your overtime take-home pay.
Proportion salaries by working hours, or calculate pro-rata rent for partial months.
Estimate the standard living wage and basic needs budget required in your cost tier.
Estimate travel payouts or tax deductions using standard annual IRS mileage rates.
Calculate standard reading and speaking times based on word count or pasted text.