Calculate Regular Pay
Use paid work hours and the regular-hour limit for the same pay period.
Example Data Table
| Worked Hours | Hourly Rate | Regular Limit | Multiplier | Regular Pay | Overtime Pay | Gross Pay |
|---|---|---|---|---|---|---|
| 46 | $22.00 | 40 | 1.5 | $880.00 | $198.00 | $1,078.00 |
Formula Used
IF(Worked Hours ≤ Regular-Hour Limit, Worked Hours × Hourly Rate, Regular-Hour Limit × Hourly Rate)
MAX(0, Worked Hours − Regular-Hour Limit)
Overtime Hours × Hourly Rate × Overtime Multiplier
Regular Pay + Overtime Pay
Spreadsheet example: =IF(B2<=C2,B2*A2,C2*A2)
How to Use This Calculator
- Enter total paid hours for one pay period.
- Enter the agreed base hourly rate.
- Set the regular-hour limit for that period.
- Add the overtime multiplier used by your policy.
- Select a matching pay frequency and currency symbol.
- Choose decimal places, then calculate the result.
- Review regular pay, overtime pay, and gross pay.
- Download CSV or print the completed result when needed.
Regular Pay Planning Guide
Regular Pay Basics
Regular pay is the earnings for hours inside an agreed normal schedule. Many workplaces use a daily or weekly limit. The limit may be eight hours per day or forty hours per week. This calculator keeps the regular portion separate. That separation helps payroll teams explain each amount. It also prevents overtime hours from being paid at the standard rate.
How Conditional Pay Rules Work
The conditional rule is simple. When worked hours are equal to or below the limit, every hour receives the hourly rate. When worked hours exceed the limit, only the approved limit receives the regular rate. Remaining hours become overtime hours. The calculator applies this decision automatically. You still control the limit, rate, multiplier, display precision, pay frequency, and currency symbol.
Enter Reliable Hours
Accurate inputs matter. Record paid work time after removing unpaid breaks. Use decimal hours when a shift includes minutes. For example, seven hours and thirty minutes becomes 7.5 hours. Enter the hourly rate before deductions unless policy says otherwise. Set the regular-hour limit that matches the selected pay period. A weekly limit should not be used for a single daily shift.
Read Every Result
The result panel shows several figures. Regular hours show the portion protected by the IF rule. Overtime hours show time above the limit. Regular pay is the key result. Overtime pay uses the multiplier for excess hours. Gross pay combines both values. Effective hourly rate divides gross pay by worked hours. These details make quick checks easier before payroll approval.
Match Frequency and Limits
Pay frequency provides useful context. It does not change the mathematical result itself. A weekly selection should be paired with weekly hours and a regular-hour limit. A biweekly selection needs totals and limits from the same period. Monthly reporting may require special company rules. Check your employment agreement, local law, and payroll policy before using calculated values for final payment.
Spreadsheet Formula
The formula can be used in a spreadsheet. Place the hourly rate in A2, worked hours in B2, and regular-hour limit in C2. Regular pay can use IF(B2<=C2,B2*A2,C2*A2). This returns the correct standard-pay amount on either side of the threshold. A separate formula can calculate overtime. Keeping formulas separate makes audits and changes easier.
Check a Practical Example
Use the example table. With 46 worked hours, a rate of 22, and a 40-hour limit, the regular pay is 880. Six hours remain for overtime. At a 1.5 multiplier, overtime pay is 198. Gross pay is 1,078. Change any input and compare the result with payroll records. Small differences often identify a missed break or incorrect limit.
Use Results Carefully
This tool supports planning and checking. It does not replace a payroll system, contract, or legal review. Taxes, benefits, bonuses, commissions, tips, and special premiums are outside the core calculation. Keep the exported result with time records when useful. Review unusual shifts and document notes. Check each payroll period against records. Use it to keep each regular payroll calculation consistent.
Frequently Asked Questions
What does regular pay mean?
Regular pay is the money earned for hours within the approved regular-hour limit. It uses the base hourly rate. Hours above the limit may qualify for overtime under your workplace rules.
How does the IF rule work?
The rule compares worked hours with the regular-hour limit. It pays all hours at the base rate when they stay within the limit. It caps regular pay at the limit when worked hours go above it.
What happens when hours equal the limit?
All worked hours count as regular hours. Overtime hours remain zero because the employee did not work beyond the approved regular-hour limit.
Can I use decimal hours?
Yes. Decimal hours help record partial hours accurately. For example, 7.5 represents seven hours and thirty minutes. Use the same time method throughout the pay period.
Does the overtime multiplier change regular pay?
No. The multiplier applies only to hours above the regular-hour limit. Regular pay always uses the entered base hourly rate.
Does pay frequency change the formula?
No. It gives context for the hours and regular-hour limit. Always use figures from the same daily, weekly, biweekly, semimonthly, or monthly period.
Can I enter unpaid break time?
Enter paid work hours only. Remove unpaid breaks first, unless your employer treats those breaks as paid time under its policy.
Are taxes included in the result?
No. The calculator shows pre-tax pay figures. Taxes, benefit deductions, retirement contributions, and other withholdings require separate payroll calculations.
Can I use this for salary calculations?
It is designed for hourly pay. You may convert an approved salary to an hourly equivalent first, but confirm that method with your employer or payroll policy.
Why is gross pay shown?
Gross pay combines regular and overtime pay. It gives a useful pre-deduction total for checking a timesheet or comparing expected earnings.
Why download the calculation?
Use it to keep each regular payroll calculation consistent.