Timesheet Overtime Calculation Formula

This calculator works out overtime pay from a timesheet. You enter the regular hourly rate, the total hours worked, and the overtime hours (or the total hours and the standard threshold), and it returns the overtime pay amount and the total pay including regular wages. The standard formula is: Overtime Pay = Overtime Hours × Overtime Rate, where the overtime rate is typically 1.5 times the regular rate (time-and-a-half).

Formula

The core formula for overtime pay is:

Overtime Pay = Overtime Hours × Regular Hourly Rate × Overtime Multiplier

Where:

• Overtime Hours – the number of hours worked beyond the standard workweek (usually 40 hours in the US, but it can vary by country or employer policy). Unit: hours.
• Regular Hourly Rate – the employee’s normal pay per hour before any overtime multiplier. Unit: currency per hour (e.g., $/hr).
• Overtime Multiplier – the factor applied to the regular rate for overtime hours. The most common is 1.5 (time-and-a-half), but some employers use 2.0 (double time) for holidays or very long shifts. Unit: dimensionless.

Total pay is then:

Total Pay = (Regular Hours × Regular Rate) + (Overtime Hours × Regular Rate × Multiplier)

This is the standard “straight-time plus overtime� method. It assumes that regular hours are paid at the base rate and overtime hours are paid at the premium rate.

Worked Example

Using the default values from the calculator above:

• Hourly rate = $20
• Regular hours = 40
• Overtime hours = 5
• Multiplier = 1.5

Step 1: Calculate regular pay.

Regular Pay = 40 × $20 = $800

Step 2: Calculate overtime pay.

Overtime Pay = 5 × $20 × 1.5 = 5 × $30 = $150

Step 3: Add them together.

Total Pay = $800 + $150 = $950

The calculator shows the same: overtime pay $150.00, regular pay $800.00, total $950.00.

When to Use This Formula

This formula applies whenever an employee is eligible for overtime under federal, state, or local law, or under an employment contract. In the United States, the Fair Labor Standards Act (FLSA) requires overtime pay of at least 1.5 times the regular rate for hours worked over 40 in a workweek. However, not all employees are eligible – some are classified as “exempt� (e.g., certain salaried professionals, executives, or outside salespeople). Always check the applicable labor laws in your jurisdiction before applying the formula.

The formula is also used for:

• Calculating pay for hourly employees who work extra shifts.
• Estimating labor costs for a project that may require overtime.
• Verifying that a paycheck is correct.
• Budgeting for overtime in a business.

How to Read the Result

The first output, Overtime Pay, is the additional money earned for the overtime hours alone. It does not include regular pay. The Total Pay is the sum of regular and overtime pay – that is the gross amount before taxes and deductions.

If you are an employer, this is the gross wage expense for that employee for the week. If you are an employee, this is the amount that should appear on your pay stub before any withholdings.

Remember that this is gross pay. Net pay (what you take home) will be lower after federal, state, and local taxes, Social Security, Medicare, and other deductions.

Common Mistakes and Misconceptions

• Using the wrong overtime threshold. In the US, the standard is 40 hours per week, but some states have daily overtime rules (e.g., California requires overtime for over 8 hours in a day). Always use the correct threshold for your situation.
• Forgetting to include bonuses or commissions. Under the FLSA, the regular rate may include nondiscretionary bonuses, commissions, and other payments. If you only use the base hourly rate, you may underpay overtime.
• Using 1.5 for all overtime. Some employers pay double time (2.0) for Sundays, holidays, or after a certain number of hours. Check your contract or local law.
• Mixing up hours and minutes. If an employee works 40 hours and 30 minutes, that is 40.5 hours, not 40.3. Convert minutes to decimal hours by dividing by 60.
• Applying overtime to a two-week period. Overtime is calculated per workweek, not per pay period. If you pay biweekly, you must separate hours for each week and calculate overtime separately for each.

Limits of the Formula

This formula is a simplified model. It does not account for:

• State-specific overtime rules (e.g., daily overtime, double-time thresholds).
• Overtime based on a “fluctuating workweekâ€� method for salaried nonexempt employees.
• Overtime on overtime (some jurisdictions require a higher rate after a certain number of hours).
• Bonuses, tips, or commissions that affect the regular rate.
• Taxes, benefits, or other withholdings.

For precise payroll, consult a labor law attorney or a certified payroll professional.

Alternatives and Related Calculations

If you need more than basic overtime pay, consider these related calculations:

• Salary to hourly conversion – to find the hourly rate for salaried employees.
• Time card calculator – to total hours from start and end times.
• Gross pay calculator – includes multiple pay types, bonuses, and deductions.
• Overtime calculator with double time – some tools let you specify different multipliers for different hour brackets.

For a small business, a spreadsheet with this formula can work, but dedicated payroll software often automates overtime calculations and compliance.

Frequently Asked Questions

What is time-and-a-half?

Time-and-a-half means the overtime multiplier is 1.5. So if your regular hourly rate is $20, your overtime rate is $30 per hour. This is the most common overtime rate under the FLSA.

How do I calculate overtime if I work 45 hours a week?

Subtract the standard 40 hours from 45 to get 5 overtime hours. Then apply the formula: Overtime Pay = 5 × hourly rate × 1.5. For example, at $20/hour, overtime pay = 5 × $20 × 1.5 = $150.

Is overtime calculated on a daily basis or weekly basis?

It depends on the law. Under federal law (FLSA), overtime is based on a weekly threshold of 40 hours. Some states, like California, also require daily overtime for hours over 8 in a day. Always check your local regulations.

Do salaried employees get overtime?

Some salaried employees are exempt from overtime, but not all. The FLSA has specific tests based on salary level and job duties. If an employee is classified as nonexempt, they must receive overtime even if they are paid a salary. The regular rate is calculated by dividing the weekly salary by the number of hours the salary is intended to cover.

Can overtime pay be paid in comp time instead of money?

In the private sector, comp time (time off in lieu of overtime pay) is generally not allowed under the FLSA. Public sector employers may offer comp time under certain conditions. Always verify with your state labor department.

What is double time?

Double time means the overtime multiplier is 2.0. It is often required for working on holidays, Sundays, or after a certain number of hours in a day or week. For example, some states require double time for hours over 12 in a day.

Related

• Switch Between Wired and Wireless CarPlay or Android Auto
• Running Total in Table: How to Calculate It
• Kunlun Tech Matrix Game: Best Resolution, Frame Rate & Memory Settings

in rate | Hourly rate | $ | 20 | 0
in reg_h | Regular hours | h | 40 | 0
in ot_h | Overtime hours | h | 5 | 0
in mult | Overtime multiplier | - | 1.5 | 0
out ot_pay | Overtime pay | $ | ot_h * rate * mult | 2
out reg_pay | Regular pay | $ | reg_h * rate | 2
out total | Total pay | $ | reg_pay + ot_pay | 2