ZorantaGuides
Clocktape

Clocktape › Guides

How to Calculate Hours Worked: Start, End, Breaks and Weekly Total

To calculate hours worked, subtract the start time from the end time for each shift, take off any unpaid break, then add the daily figures together. Do the adding in hours and minutes, and convert to decimal hours only at the end, for example 38:50 becomes 38.83 hours.

A shift from 8:30 to 17:15 with a 30-minute unpaid lunch is 8:45 − 0:30 = 8:15. The steps and a full example week are below.

A strip of paper tape next to a wristwatch and a pencil

How to calculate hours worked, step by step

  1. Write each start and end time in 24-hour form. 5:40 pm becomes 17:40, 9:10 am stays 9:10. This removes the am/pm mix-ups.
  2. Subtract start from end. 17:40 − 9:10 = 8:30. If the minutes on the end time are smaller, borrow an hour: 17:15 − 8:30 is the same as 16:75 − 8:30 = 8:45.
  3. Take off unpaid breaks. An 8:45 shift with a 30-minute unpaid lunch is 8:15 worked.
  4. Add the days. Add the hours and the minutes separately, then turn every 60 minutes into one more hour.
  5. Convert to decimal hours if your timesheet or pay rate needs it. Divide the leftover minutes by 60: 50 minutes ÷ 60 = 0.83.

If the end time is earlier than the start time, the shift ran past midnight. Add 24 hours to the end time before subtracting; our guide to calculating hours worked overnight walks through it.

Clocktape

Clocktape adds hours and minutes on a tape: type 9:10a → 5:40p − 0:30 on one line per day, and the total shows as h:mm, decimal hours and minutes together. Get it on Google Play

A worked example: one week on a time card

Here is a five-day week with different start times and breaks. Each line is worked out on its own first.

DayStart → endShift lengthUnpaid breakHours worked
Mon8:30 → 17:158:450:308:15
Tue8:00 → 16:458:450:308:15
Wed9:10 → 17:408:300:457:45
Thu8:15 → 17:008:450:308:15
Fri8:00 → 14:206:20none6:20

Now add the last column. Hours: 8 + 8 + 7 + 8 + 6 = 37. Minutes: 15 + 15 + 45 + 15 + 20 = 110. 110 minutes is 1 hour 50 minutes, so the week is 38:50.

Same total, three waysValue
Hours and minutes38:50
Decimal hours38 + 50 ÷ 60 = 38.83
Minutes38 × 60 + 50 = 2,330

How to calculate hours worked in decimals

Payroll and many timesheets multiply hours by an hourly rate, and that only works with decimal hours. The conversion is minutes ÷ 60. A common slip is to treat the minutes as if they were already a decimal.

Time workedWrongRight
7:457.457.75
8:158.158.25
6:206.206.33
38:5038.5038.83

Typing 7:45 as 7.45 loses 0.30 of an hour, which is 18 minutes. Over a week of entries like that the gap adds up. Our minutes to decimal hours chart lists every minute from 1 to 60.

Check the pay figure from the exact total

At an example rate of $18 an hour, 38:50 is exactly 38⅚ hours, so the pay is $699.00. If you round to 38.83 first, you get 38.83 × 18 = $698.94. Six cents is small, but it shows why it helps to keep the hours and minutes total and round once, at the end, to the number of decimal places your employer uses.

What usually counts as time worked

The arithmetic is the easy part. The harder question is which minutes go on the time card. In the United States, the Department of Labor's Fact Sheet #22 on hours worked explains how federal rules treat short rest breaks, meal periods, on-call time and travel. As a rule of thumb from that guidance:

State rules, union agreements and your employer's policy can add to this. When you are unsure, ask how your employer records breaks before you start subtracting them.

Hours worked per week, month and year

Once you have the daily figures, the bigger totals are just more of the same addition:

Keep large totals in hours rather than days. A year of shifts might come to 1,284:35, and writing it as "53 days" makes it much harder to check against a timesheet.

Spreadsheet version

In Excel or Google Sheets, put the start in column A, the end in column B and the break in column C. =(B2-A2-C2)*24 gives decimal hours for a daytime shift. Format a sum of times as [h]:mm so totals above 24 hours do not roll over into days.

This page explains time arithmetic only. It is not payroll, legal or tax advice. Which hours count as paid work depends on your employer and the law where you work; check the official guidance or ask your payroll team.
Clocktape

Add up your week without the borrowing

In Clocktape each line keeps its own result, so you can fix Tuesday's end time and watch the weekly total update.

Get it on Google Play

iPhone version coming soon

More guides

All guides

Sources

Published by Zoranta, the developer of Clocktape.