How to calculate hours worked

Five steps from clock times to payroll hours, with the three mistakes that most often go wrong.

Last reviewed by Time Card Calculator Tool

Work it out on your own hours: Hours worked calculator, free with no sign-up.

Adding up hours by hand trips people up because time does not count in tens. Sixty minutes make an hour, twelve hour clocks restart at noon, and night shifts end on a different day from the one they started. The method below works for any shift and gives the same answer as the calculators on this site.

Step 1: convert both times to 24 hour time

Morning times stay the same (9:15 AM is 09:15). For afternoon and evening times, add 12 to the hour (5:30 PM is 17:30). Noon is 12:00 and midnight is 00:00. The military time chart lists every hour.

Step 2: subtract the start from the end

Subtract hours from hours and minutes from minutes. If the end minutes are smaller than the start minutes, borrow an hour: take 1 from the end hour and add 60 to the end minutes.

StartEndBorrow?Result
08:1516:45No8 h 30 min
08:4017:10Yes: 16:70 − 08:408 h 30 min
06:5515:05Yes: 14:65 − 06:558 h 10 min

Step 3: handle shifts that cross midnight

If the end time is earlier than the start time, the shift ran past midnight. Add 24 hours to the end time before subtracting. A shift from 22:00 to 06:30 becomes 30:30 − 22:00 = 8 h 30 min.

Step 4: take away unpaid breaks

Subtract only unpaid meal breaks, usually 30 or 60 minutes. Short rest breaks are paid time and stay in. See are lunch breaks paid for where the line falls.

Step 5: convert minutes to decimal for pay

Divide the minutes by 60 and add them to the hours. 8 h 30 min is 8.5 hours; 8 h 10 min is 8.17 hours. Multiply decimal hours by the hourly rate to get pay. The minutes to decimal chart saves the division.

Adding up a week

Total the days in hours and minutes, then carry every 60 minutes into an extra hour. Five days of 8:20 is 40 hours plus 100 minutes, which is 41 hours 40 minutes, or 41.67 hours. That total is also what the overtime test uses: anything over 40 hours in the workweek is overtime under federal law, so this week has 1.67 overtime hours.

The three most common mistakes

  1. Treating minutes as a decimal. Writing 8 h 30 min as 8.30 instead of 8.50 loses 12 minutes a day.
  2. Forgetting the AM/PM switch. 8:00 to 4:30 is not −3.5 hours; convert 4:30 PM to 16:30 first.
  3. Subtracting paid breaks. A 15 minute rest break is paid; only the unpaid meal comes off.

Let the calculator do it

For one shift, the hours worked calculator takes a start, end and break. For a whole week or pay period, the time card calculator adds every day, applies overtime and shows pay. Both use the same method described here, so you can check one against the other.

Frequently asked questions

How many hours is 8 AM to 5 PM?

Nine hours on the clock. With a one hour unpaid lunch it is 8 hours worked; with a 30 minute lunch it is 8.5 hours.

How do I calculate hours worked in Excel?

Put the start and end times in two cells as Excel times, then use =(B1-A1+(B1<A1))*24 to get decimal hours. The (B1<A1) part adds a day for shifts that cross midnight. Subtract the break in hours, for example -0.5.

How do I add hours and minutes together?

Add the hours and the minutes separately, then turn every 60 minutes into one hour. 7:45 plus 8:30 is 15 hours 75 minutes, which is 16 hours 15 minutes.

Recommended Employee Time Clocks & Payroll Supplies

Commercial biometric time clocks, punch machines, and audit supplies to eliminate buddy-punching and maintain wage compliance.

Affiliate Disclosure
Touchless Biometric Subscription-Free

Biometric Face Recognition & Fingerprint Time Clock (No Monthly Fee)

Standalone Wi-Fi and USB attendance machine with AI facial recognition and fingerprint sensor. Exports automated Excel payroll reports directly without any recurring monthly software subscriptions.

Available on Amazon Check Price on Amazon
Mechanical Punch Overtime Flagging

Commercial Electronic Punch Clock with Two-Color Ribbon Printing

Durable commercial punch station featuring automatic card feed, precision micro-switch activation, and two-color printing that flags early punches, tardiness, and overtime in red.

Available on Amazon Check Price on Amazon
RFID Badge System Fast Shift Changes

RFID Proximity Badge Attendance Terminal with USB & Network Sync

High-speed badge-tap time clock designed for fast shift changes. Employees clock in under one second using contactless RFID key fobs or badges, minimizing shift start bottlenecks.

Available on Amazon Check Price on Amazon
Payroll Accounting Audit Verification

Desktop Financial Printing Adding Machine with Tax & Audit Tape

Commercial 2-color ribbon printing calculator with high-speed paper tape printout for fast verification of weekly hours, overtime premiums, and gross pay audit trails.

Available on Amazon Check Price on Amazon
Workplace Organization Payroll Setup

Heavy-Duty 24-Pocket Steel Wall-Mounted Time Card Rack

Industrial powder-coated steel expanding pocket rack for organizing standard employee punch cards, badges, and timesheets right next to the clock-in terminal.

Available on Amazon Check Price on Amazon
Compliance Paper Records FLSA Compliance

Universal Weekly & Bi-Weekly Employee Time Cards (500 Pack)

Heavy 143 lb cardstock time sheets with standard morning, lunch, and afternoon in/out slots, overtime tracking boxes, and employee signature lines for FLSA audit compliance.

Available on Amazon Check Price on Amazon

Workplace Time Tracking System Comparison

Compare hardware options for recording employee attendance, preventing buddy punching, and preparing audit-ready records:

System Hardware Ideal Use Case Ongoing Software Cost Audit Records
Face & Fingerprint Biometric Clock Offices, clinics, warehouses wanting zero buddy-punching Zero recurring fees; USB or Wi-Fi download Digital Excel export with exact punch timestamps
Electronic Thermal / Ribbon Punch Clock Retail shops, auto garages, restaurants Replacement ink ribbons and paper cards Physical stamped paper time card with red late flags
RFID Contactless Badge Terminal Manufacturing and high-volume shift changes (50+ workers) Zero subscription fees; RFID fobs or cards One-second contactless punch log with LAN sync
Manual Heavy Cardstock Timesheet System Field trailers, job sites, and small contractor crews Replacement cards only Signed physical record kept for 3-year FLSA retention

FLSA Payroll Compliance Tip (29 CFR 516 Record Retention)

Federal law requires employers to preserve basic payroll records for at least three years, and all supplementary records (including daily time cards, clock tapes, and wage rate tables) for at least two years. Having stamped punch records or immutable biometric logs signed by employees protects business owners from disputed back-wage claims during Department of Labor wage audits.

As an Amazon Associate we earn from qualifying purchases. Product recommendations are editorially independent.