Overtime Calculator

Use this overtime calculator to compute regular pay, overtime pay, and total pay based on four simple inputs:

  • Hourly rate
  • What’s considered regular hours (day or week)
  • Overtime multiplier
  • Total hours worked during the period (day or week)

Then, turn the overtime pay calculator into a time card by adding an employee’s name and work period. Then, print or save the PDF version.

Overtime Calculator

$

Results

Overtime Pay Calculator Instructions

Follow these steps to use the overtime rate calculator above.

  1. Employee (optional): Enter a name if you’d like to save or print the time card.
  2. Time period (optional): Enter a start date, range of dates, or any other note here. It’s an open-text field and won’t factor into the calculation.
  3. How much do you make per hour? Enter your hourly pay rate for regular work hours.
  4. How many hours are considered “regular work hours”? Enter the amount of hours in a given time period that are considered full-time.
    • Daily example: If you’re calculating daily overtime pay, you’ll likely put 8.
    • Weekly example: If you’re calculating weekly overtime pay, you’ll likely put 40.
  5. What is your overtime multiplier? Enter the amount we should multiply your regular hourly rate by to get your overtime rate.
    • If you make $150 in overtime and $100 regular, you’ll put 1.5 ($150/$100).
    • If you get “time and a half,” enter 1.5
    • If you get “double time,” enter 2.
  6. How many hours did you work during this period? Enter the total amount of hours you worked in the period (any period like day or week). Ignore regular or OT hours. We’ll sort those out for you.

The OT calculator will compute as you enter the inputs and spit out the following:

  • Regular hours worked
  • Overtime hours worked
  • Regular pay
  • Overtime pay
  • Total pay

How To Calculate Overtime Pay

Below, you’ll find two ways to calculate your overtime pay for a given time period (like a day or a week). First, you’ll see the formula to calculate overtime. Then, you’ll see written-out steps.

Overtime Calculation Formula

To calculate your hourly rate from your annual salary, use this formula:

Overtime pay = (total hours – regular hours) * regular hourly rate * overtime multiplier

Here are some supporting formulas you may need, too:

  • Overtime multiplier = overtime hourly rate / regular hourly rate
  • Overtime hours worked = total hours worked – regular hours

Steps To Calculate Overtime Pay

  1. Identify Your Regular Hourly Rate: Gather how much you make per hour. This is your regular hourly wage.
  2. Determine the Overtime Rate: Gather your overtime pay rate, which needs to be listed as a multiple of your regular pay like one of these:
    • Time and a half = 1.5
    • Double time = 2
  3. Record Your Regular Hours Worked: Note how many hours you work during a standard workweek (before overtime kicks in). The threshold for overtime depends on local laws but is often set at 40 hours per week in many regions.
  4. Record Your Overtime Hours Worked: Track any hours worked over the standard threshold for a workweek.
  5. Calculate Overtime Pay: Multiply the number of overtime hours by the overtime rate (e.g., 1.5 times your regular rate).
  6. Sum Up Total Earnings: Add your regular pay (regular hours times regular rate) to your overtime pay to get your total earnings for the period.

Example Calculation

If the hourly rate is $100, the regular work hours threshold is 40 hours, the overtime multiplier is 1.5, and the total hours worked is 45 hours:

  • Regular Pay = $100 × 40 = $4,000
  • Overtime Pay = $100 × 1.5 × (45 – 40) = $750
  • Total Earnings = $4,000 + $750 = $4,750

Overtime Calculation Excel Spreadsheet

If you’d rather do your calculation in Excel, use this spreadsheet template.

Related Resources

We have several helpful calculators and templates to help you manage your work hours, staff, and schedules. Here are some closely related ones you might find useful.

Income & Salary Calculators

Here are a few other free calculators we’ve built that are closely related to our overtime calculator.

Work Schedule Templates

Here are some additional templates you might find useful for managing your team’s work schedule:

Disclaimer: This calculator is not legal advice. Please advise your HR or legal team first to determine the right work hour calculations and salaries depending on your type of organization, employee status, and labor laws in your state or country.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *