How to calculate hours worked, step by step
- 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.
- 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.
- Take off unpaid breaks. An 8:45 shift with a 30-minute unpaid lunch is 8:15 worked.
- Add the days. Add the hours and the minutes separately, then turn every 60 minutes into one more hour.
- 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 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.
| Day | Start → end | Shift length | Unpaid break | Hours worked |
|---|---|---|---|---|
| Mon | 8:30 → 17:15 | 8:45 | 0:30 | 8:15 |
| Tue | 8:00 → 16:45 | 8:45 | 0:30 | 8:15 |
| Wed | 9:10 → 17:40 | 8:30 | 0:45 | 7:45 |
| Thu | 8:15 → 17:00 | 8:45 | 0:30 | 8:15 |
| Fri | 8:00 → 14:20 | 6:20 | none | 6: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 ways | Value |
|---|---|
| Hours and minutes | 38:50 |
| Decimal hours | 38 + 50 ÷ 60 = 38.83 |
| Minutes | 38 × 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 worked | Wrong | Right |
|---|---|---|
| 7:45 | 7.45 | 7.75 |
| 8:15 | 8.15 | 8.25 |
| 6:20 | 6.20 | 6.33 |
| 38:50 | 38.50 | 38.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:
- Short rest breaks are generally counted as paid time, so you do not subtract them.
- A real meal period, where you are fully relieved from duty, is generally not counted, so you do subtract it.
- If you eat at your desk and keep answering the phone, that is not a break from work.
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:
- Per week: add the seven days of your workweek. An employer's fixed workweek does not have to start on Monday, so check which day yours begins.
- Per pay period: add the weeks or days in the period. For a biweekly period, add two workweeks; for a semi-monthly one, add the actual days in that half-month.
- Per month or year: add the real weeks or pay periods. Estimates such as weekly hours × 52 are fine for planning, but a time card total should come from the days you actually worked.
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.
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 PlayiPhone version coming soon
More guides
- How to Calculate Hours Worked Overnight (Shifts Past Midnight)When a shift ends after midnight, add 24 hours to the end time before subtracting. Night shift examples, breaks, splitting at midnight and spreadsheet formulas.
- Minutes to Decimal Hours: Formula and Conversion ChartConvert minutes to decimal hours by dividing by 60. Full chart from 1 to 60 minutes, the reverse conversion, rounding to 1, 2 or 3 places, and common time card mistakes.
- Adding Hours and Minutes Together (and Subtracting Them)Add hours and minutes by adding each part, then carrying every 60 minutes into an hour. Examples for subtracting, totals over 24 hours, seconds, and multiplying time.
- How to Calculate Overtime Hours from a Time CardOvertime hours are the hours worked beyond your threshold. Total the week in hours and minutes, subtract the threshold, convert to decimals, check daily and weekly rules.
Published by Zoranta, the developer of Clocktape.