1. Work hours
  2. Payroll hours calculator

Payroll hours calculator

Total each employee's hours for a weekly or biweekly pay period and split them into regular and overtime hours, one workweek at a time. Totals come out in decimal hours, ready for payroll entry.

Pay period

Type hours as decimals (40.5) or hours and minutes (40:30). Rate is optional; add it to see gross pay.

Example rows (grey) count. Type over them.

Hours by employee and workweek
EmployeeHourly rateWeek 1Week 2TotalRemove

Total hours
0.000:00
Regular
0.000:00
Overtime 1.5x
0.00 
Standard for period
80.00per full-time employee
Gross pay
Add a rate 
Payroll hours

Example values. Type over them.

0.00

    Rule used: US federal (FLSA). 1.5x the regular rate for hours over 40 in each workweek; weeks are never averaged. 29 CFR 778.104. State daily overtime is not applied here.

    The CSV has one row per employee with decimal totals, ready to paste into a spreadsheet or payroll import.

    How to calculate payroll hours

    These steps show the US federal rule. If you choose another rule, the tool uses that rule instead.

    1. Total each employee's hours for each workweek in the pay period.
    2. For each workweek, hours up to 40 are regular and hours over 40 are overtime.
    3. Add the workweeks together for the period's regular and overtime hours.
    4. Convert minutes to decimal hours (divide by 60) before entering them in payroll.

    Overtime hours = hours over 40, counted for each workweek on its own
    Payroll hours = regular hours + overtime hours

    A workweek is a fixed, recurring run of 168 hours that the employer sets. It can start on any day and at any hour, and it can be changed only if the change is meant to be permanent and not to avoid overtime.

    29 CFR 778.104, 778.105.

    Worked example

    Three employees on a biweekly payroll. Ben works 30 hours in week 1 and 50 in week 2.

    One biweekly pay period
    EmployeeWeek 1Week 2RegularOvertimeGross
    Ana, $20.004040800$1,600.00
    Ben, $18.0030507010$1,530.00
    Cleo, $25.0045.538785.5$2,156.25
    Pay period115.512822815.5$5,286.25

    Ben averages 40 hours a week, but each workweek stands alone. Week 2 has 10 overtime hours: 30 × $18.00 + 40 × $18.00 + 10 × $27.00 = $1,530.00. Counting the two weeks as one 80-hour block would have paid him $1,440.00, which is $90.00 short.

    Hours in each pay period

    A full-time schedule of 40 hours a week is 2,080 hours a year (40 × 52). Divided by the number of pay periods:

    Pay periodPeriods a yearStandard hours
    Weekly5240.00
    Biweekly2680.00
    Semi-monthly2486.67
    Monthly12173.33

    Semi-monthly and monthly periods do not line up with workweeks, so a workweek can start in one pay period and end in the next. Overtime is still counted on the whole workweek. That is why this calculator takes hours by workweek and offers weekly and biweekly periods, where the weeks fit exactly. The semi-monthly vs biweekly guide shows how many hours each 2027 semi-monthly period really holds.

    Rounding clock times

    Employers may round clock-in and clock-out times to the nearest 5 minutes, tenth of an hour or quarter hour, as long as the rounding does not end up underpaying employees over time.

    29 CFR 785.48(b).

    Questions

    How many hours is a semi-monthly pay period?

    86.67 hours on average for a 40-hour schedule: 2,080 hours a year divided by 24 periods. The real figure depends on how many workdays fall in that half-month.

    How do I convert minutes to decimal hours for payroll?

    Divide the minutes by 60: 15 minutes is 0.25 and 45 minutes is 0.75, so 7 hours 20 minutes is 7 + 20 ÷ 60 = 7.33 hours. The calculator accepts either form.

    Sources

    1. 29 CFR 778.104, Each workweek stands alone (eCFR)
    2. 29 CFR 778.105, Determining the workweek (eCFR)
    3. U.S. Department of Labor, Wage and Hour Division: Overtime Pay
    4. 29 U.S.C. 207, Maximum hours
    5. 29 CFR 785.48, Use of time clocks (eCFR)
    Tested against
    Published test cases

    The calculator runs in your browser and does not store the hours, names or wages you enter.

    Related tools