To calculate payroll hours, record each work interval, subtract only valid unpaid time, total the hours by workweek, separate regular and overtime hours under the applicable rules, and multiply each category by the correct rate. Keep the original time record, review exceptions, and apply the company’s rounding and break policies consistently.
This guide explains the arithmetic, not every wage-and-hour requirement. Federal, state, local, union, and contract rules can differ. Payroll and legal professionals should confirm the treatment for each workforce.
Payroll-hours formula
For one shift:
Hours worked = clock-out time − clock-in time − unpaid break
For a workweek:
Total weekly hours = sum of all daily work intervals
When federal overtime rules apply to a nonexempt employee:
Regular hours = up to 40 hours in the fixed workweek
Overtime hours = hours over 40 in that workweek
Some jurisdictions, wage orders, agreements, or special rules use daily overtime, double time, or other thresholds. Do not assume the federal weekly rule is the only rule that matters.
Step-by-step calculation
-
Confirm the workweek and employee classification
Define the fixed seven-day workweek used for overtime. Confirm whether the employee is nonexempt or exempt and which jurisdictional or contractual rules apply.
Do not average two workweeks in a biweekly pay period to erase overtime. Payroll may be processed every two weeks, but federal overtime for covered nonexempt employees is generally evaluated by workweek.
-
Collect all work intervals
Use clock-in, clock-out, meal, split-shift, call-back, travel, training, and other compensable-time records as applicable. Resolve missing punches with the employee and preserve the correction history.
-
Convert times consistently
The safest manual method is 24-hour time.
For consistent arithmetic, convert clock times to a single format: 8:15 a.m. becomes 08:15, 12:30 p.m. remains 12:30, 5:45 p.m. becomes 17:45, and 11:10 p.m. becomes 23:10.
Convert minutes to decimal hours only after calculating the actual minutes:
Decimal hours = total minutes ÷ 60
Examples: 15 minutes = 0.25 hour; 30 minutes = 0.50; 45 minutes = 0.75. Do not treat 8 hours 30 minutes as 8.30 hours.
-
Subtract valid unpaid breaks
Subtract only breaks that are unpaid under the applicable rule and during which the employee is actually relieved of duty. If an employee works through a meal period, the time may be compensable even if the schedule shows a break.
-
Total each day and workweek
Keep unrounded minutes during the calculation when practical. If the organization uses a lawful rounding policy, apply it consistently and verify that the practice does not systematically undercount work.
-
Separate regular and overtime hours
Apply the correct rule for the employee’s jurisdiction and agreement. Review multiple rates, shift differentials, bonuses, and other compensation that may affect the regular rate used for overtime.
-
Calculate gross wages
For a simple case with one hourly rate:
Regular wages = regular hours × hourly rate
Overtime wages = overtime hours × overtime rate
Gross wages = regular wages + overtime wages + other earnings
The overtime rate may not always be a simple 1.5 times the base rate because the regular-rate calculation can include other remuneration. Use payroll expertise for bonuses, multiple rates, and special payments.
Worked payroll-hours example
Assume a nonexempt employee works the following time in one workweek. For simplicity, the example uses one hourly rate and a weekly overtime threshold after 40 hours.
In the worked week, Monday and Tuesday each total 8.50 hours after a 30-minute unpaid break. Wednesday totals 9.00, Thursday 8.50, and Friday 8.00. The weekly total is 42.50 hours. The final split between regular and overtime pay depends on the applicable workweek and wage rules.
Regular hours: 40.00
Overtime hours: 2.50
At a base rate of $24.00 per hour and a simple 1.5 overtime rate:
Regular wages: 40 × $24.00 = $960.00
Overtime wages: 2.5 × $36.00 = $90.00
Gross wages before other earnings and deductions: $1,050.00
Cross-midnight shift example
For a shift from 10:00 p.m. to 6:30 a.m. with a 30-minute unpaid meal:
22:00 to 24:00 = 2 hours
00:00 to 06:30 = 6.5 hours
total elapsed time = 8.5 hours
less 0.5-hour unpaid meal = 8.0 hours worked
Assign the time to the workweek and day under the company’s lawful payroll configuration. Do not split it arbitrarily in a way that changes overtime treatment.
Common payroll-hour mistakes
Using decimal time incorrectly
8:45 is a clock time. 8.75 is decimal hours. They are equivalent only after converting 45 minutes to 0.75 hour.
Deducting scheduled meals automatically
A schedule does not prove the employee was relieved of duty. Create a way to report missed or interrupted meals.
Ignoring work outside scheduled hours
Compensable work may include pre-shift setup, post-shift closing, required messages, or other work the employer knows or should know is being performed. Address unauthorized overtime through policy; do not remove actual work from the record.
Averaging workweeks
An employee who works 45 hours in week one and 35 in week two has 80 hours in the pay period, but the weekly overtime analysis is not the same as two 40-hour weeks.
Overwriting corrections
Keep the original punch, corrected value, reason, employee confirmation, timestamp, and approval.
Payroll timekeeping controls
The U.S. Department of Labor’s FLSA recordkeeping guidance describes records covered employers generally must maintain. A practical control process also includes:
- a written workweek, time-entry, break, overtime, and correction policy;
- employee access to review the timecard;
- supervisor review of missing punches, long shifts, and changes;
- a way to report unrecorded work without retaliation;
- locked pay periods with controlled post-close corrections;
- reconciliation between approved time and payroll output;
- periodic testing of rounding, automatic deductions, and integrations.
Reconciling desktop time with payroll records
KeepActive may provide supplementary work-time context for approved company devices, which can help identify discrepancies or after-hours patterns for review. It should not silently replace the employee’s payroll timecard or an established correction process. Resolve differences with the employee and follow the applicable wage-and-hour rules. Automatic time tracking can support exception review, but payroll still needs an approved source of record and a documented correction path.
Build an exception report before payroll closes
Payroll reviewers should not reread every clean shift. Produce an exception queue for overlapping intervals, missing punches, long or missing breaks, cross-midnight work, retroactive edits, hours outside the scheduled range, duplicate entries, and overtime near a threshold. Each item needs an owner and a visible resolution.
Close the queue before calculating final wages, then reconcile paid hours with the approved time record and preserve both versions. A useful control also tracks recurring exception causes by location, manager, device, and rule. Ten identical corrections are usually a process defect, not ten unrelated employee mistakes.
Accurate payroll starts with accurate intervals
Payroll should be reproducible from the original time records through every adjustment to the final check. If a reviewer cannot follow that path, the arithmetic may be right but the control is not.
FAQ (Frequently Asked Questions): Find Answers and Solutions:
How do you convert payroll minutes to decimals?
Divide minutes by 60. Ten minutes is 0.1667 hour, 20 minutes is 0.3333, 30 minutes is 0.5, and 45 minutes is 0.75. Let the payroll system preserve appropriate precision.
Do you subtract lunch from payroll hours?
Only when the meal period is unpaid under the applicable rules and the employee is relieved of duty. If the employee works through the meal, the time may need to be paid.
Is overtime calculated per day or per week?
Federal overtime for covered nonexempt employees is generally based on hours over 40 in a fixed workweek, but some states, agreements, and industries add daily or other rules. Apply the rule that governs the employee.
Can payroll round clock times?
Rounding is a legal and policy issue, not merely an arithmetic preference. Obtain advice, apply any lawful policy consistently, and audit the actual effect to ensure time is not systematically undercounted.
Contents
Share this post