How to Calculate Hours Worked: Formula and Decimal Chart
How to calculate hours worked from start and end times: subtract unpaid breaks, handle overnight shifts and convert timesheet minutes to decimal hours.
Updated
To calculate hours worked, subtract the start time from the end time, then subtract any unpaid breaks. Convert the leftover minutes to a decimal by dividing by 60, so 8 hours 30 minutes becomes 8.5 hours. Multiply the decimal hours by the hourly rate to get pay.
The four steps
- Write both times on a 24-hour clock. Add 12 to any pm hour except 12: 5:15 pm becomes 17:15. 12:00 am is 00:00 and 12:00 pm is 12:00.
- Subtract start from end. If the end minutes are smaller than the start minutes, borrow 60 minutes from the hours.
- Subtract unpaid break time.
- Convert minutes to a decimal:
minutes / 60.
Worked example: clock in 8:45 am, clock out 5:15 pm, 30 minute unpaid lunch.
17:15 - 8:45: 15 is less than 45, so borrow an hour.16:75 - 8:45 = 8:30.- Minus the break:
8:30 - 0:30 = 8:00. - Paid time is 8.0 hours.
A shortcut that avoids borrowing is to convert everything to minutes first. 17:15 is 17 x 60 + 15 = 1035 minutes and 8:45 is 525. 1035 - 525 - 30 = 480 minutes, and 480 / 60 = 8 hours.
Minutes to decimal hours chart
Payroll multiplies hours by a rate, and that only works with decimal hours. The most common timesheet error is writing 7 hours 45 minutes as 7.45. It is 7.75.
| Minutes | Decimal hours | Minutes | Decimal hours |
|---|---|---|---|
| 1 | 0.02 | 31 | 0.52 |
| 3 | 0.05 | 33 | 0.55 |
| 5 | 0.08 | 35 | 0.58 |
| 6 | 0.10 | 36 | 0.60 |
| 9 | 0.15 | 39 | 0.65 |
| 10 | 0.17 | 40 | 0.67 |
| 12 | 0.20 | 42 | 0.70 |
| 15 | 0.25 | 45 | 0.75 |
| 18 | 0.30 | 48 | 0.80 |
| 20 | 0.33 | 50 | 0.83 |
| 24 | 0.40 | 54 | 0.90 |
| 25 | 0.42 | 55 | 0.92 |
| 27 | 0.45 | 57 | 0.95 |
| 30 | 0.50 | 60 | 1.00 |
To go the other way, multiply the decimal part by 60: 0.4 hours is 0.4 x 60 = 24 minutes.
Lunch and other breaks
Only unpaid breaks come off the total. Which breaks are paid depends on your country, your state and your contract. Under US federal rules, short rest breaks of about 5 to 20 minutes count as paid working time, while a genuine meal period, usually 30 minutes or longer with no duties, does not have to be paid. Many states and most other countries have their own rules, so check the one that applies to you.
If a day has several unpaid breaks, add them up and subtract once:
- On site: 7:00 to 16:00 = 9 hours.
- Unpaid: 30 minute lunch + 15 minute break = 45 minutes.
- Paid:
9:00 - 0:45 = 8:15, which is 8.25 hours.
Overnight shifts
When a shift crosses midnight, the end time is a smaller number than the start, and plain subtraction gives a negative result. Two fixes:
- Add 24 hours to the end. For 22:00 to 06:30:
30:30 - 22:00 = 8:30. - Split at midnight.
24:00 - 22:00 = 2:00before midnight, plus6:30after, gives8:30.
Either way the answer is 8.5 hours before breaks. For payroll, also note which day or week the hours belong to. Employers define a fixed workweek, and a shift that spans the boundary may be split between two weeks.
One edge case: on the night clocks change for daylight saving time, an overnight shift is really one hour shorter or longer than the clock times suggest. Daylight saving time explained covers when that happens.
Weekly totals, rounding and overtime
Add the daily figures in decimal form, or add hours and minutes separately and carry every 60 minutes into the hours.
| Day | In | Out | Unpaid break | Hours |
|---|---|---|---|---|
| Mon | 8:45 | 17:15 | 0:30 | 8.00 |
| Tue | 8:50 | 17:35 | 0:30 | 8.25 |
| Wed | 9:00 | 18:00 | 0:30 | 8.50 |
| Thu | 8:45 | 17:45 | 0:30 | 8.50 |
| Fri | 8:30 | 16:45 | 0:30 | 7.75 |
| Total | 41.00 |
At a rate of 22 an hour, 41 hours of straight time is 41 x 22 = 902.
In the US, the Fair Labor Standards Act requires overtime pay of at least 1.5 times the regular rate for hours over 40 in a workweek for employees it covers. In the example that is 40 hours at 22 plus 1 hour at 33, which is 913. Other countries and some US states use different thresholds, including daily ones.
Many employers round clock times before calculating. US rules permit rounding to the nearest 5 minutes, tenth of an hour (6 minutes) or quarter hour, as long as it does not consistently favour the employer over time. With quarter-hour rounding, 1 to 7 minutes past rounds down and 8 to 14 rounds up, which is often called the 7-minute rule. So a punch at 8:07 counts as 8:00 and 8:08 counts as 8:15.
The Percentage Calculator is useful for the pay side, such as working out what share of the week was overtime.
In a spreadsheet
Spreadsheets store a time as a fraction of a day, so multiply a difference by 24 to get hours:
- Same-day shift:
=(B2-A2)*24 - Shift that may cross midnight:
=MOD(B2-A2,1)*24 - With an unpaid break in minutes in C2:
=MOD(B2-A2,1)*24-C2/60
Format the result cell as a number, not a time, or 8.5 will display as something like 12:00.
Using the Duration Calculator for a shift
The Duration Calculator takes a start date and time and an end date and time, so it handles overnight shifts without any trick: enter the next day's date for the clock-out. It shows the gap as hours and minutes, and as a total in minutes.
It does not subtract breaks or output decimal hours, so finish the last two steps yourself: take Total Minutes, subtract your unpaid break minutes, and divide by 60. A 22:00 to 06:30 shift shows 510 total minutes. Minus a 30 minute break is 480, and 480 / 60 = 8.0 hours.
If you would sooner time the work as it happens than reconstruct it afterwards, the Stopwatch records elapsed time with laps, which suits task-based billing.
Try it
Enter yesterday at 22:00 and today at 06:30 in the Duration Calculator. You should see 8 hours 30 minutes and 510 total minutes. Subtract your break and divide by 60 for the decimal figure your timesheet needs.