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.