English
العربية
Deutsch
Español
Français
Italiano
Português
Русский
Türkçe
Tiếng Việt
Hours Calculator
Add up worked hours and find the time between two clock times.
Adding up hours is annoying for one reason: time is base 60 and your instincts are base 10. Three shifts of 7 hours 45 minutes is not 21.35 hours, and a spreadsheet that treats it that way will quietly underpay somebody.
Calculating hours worked
- Enter the start time and the finish time.
- Subtract any unpaid break.
- Read the total in hours and minutes.
- Check the decimal figure too — that is the one payroll usually wants.
- Add further shifts to build up a weekly total.
Hours and minutes versus decimal hours
Payroll systems almost always work in decimal hours, where 30 minutes is 0.5 and 45 minutes is 0.75. Timesheets are usually filled in as hours and minutes, where 30 minutes is written as 30. Converting between the two is where errors creep in.
To convert minutes to decimal, divide by 60. So 7 hours 45 minutes is 7 + (45 ÷ 60) = 7.75 hours. Writing it as 7.45 is a common slip and shorts the employee by 18 minutes across a week of similar shifts.
Minutes to decimal hours
| Minutes | Decimal | Minutes | Decimal |
|---|---|---|---|
| 5 | 0.083 | 35 | 0.583 |
| 10 | 0.167 | 40 | 0.667 |
| 15 | 0.250 | 45 | 0.750 |
| 20 | 0.333 | 50 | 0.833 |
| 30 | 0.500 | 60 | 1.000 |
Cases that trip people up
- Overnight shifts that cross midnight — the finish time is numerically smaller than the start.
- Unpaid breaks, which have to come out before the total is calculated.
- Clock-in rounding policies, where some employers round to the nearest five or fifteen minutes.
- Overtime thresholds that kick in after a set number of hours in a week.
- Daylight saving changes, which make one day 23 hours long and another 25.
Hours calculation questions
How do I calculate hours between two times?
Convert both times to minutes past midnight, subtract, then divide by 60. From 09:15 to 17:45 is 1,065 minus 555 equals 510 minutes, which is 8.5 hours.
How do I handle a shift that crosses midnight?
Add 24 hours to the finish time before subtracting. A shift from 22:00 to 06:00 becomes 22:00 to 30:00, giving 8 hours.
How do I convert minutes into decimal hours?
Divide by 60. So 45 minutes is 0.75 hours and 20 minutes is 0.333 hours. Writing 45 minutes as 0.45 is the classic timesheet error.
Should breaks be subtracted?
Unpaid breaks, yes. Paid breaks stay in the total. Check your contract or local employment rules, since this varies by country and by employer.
Why does my total differ from my employer’s by a few minutes?
Usually rounding policy. Many systems round each clock-in and clock-out to the nearest quarter hour, which can shift a weekly total slightly in either direction.
