Hours calculator
Find the hours and minutes between two times, with breaks and overnight shifts, or add up a week of hours worked. Results update as you type.
Hours between two times
Timesheet: hours worked this week
Minutes to decimal hours
Payroll and timesheet systems often want hours as a decimal. Divide the minutes by 60 and round to two places: 15 minutes is 0.25 hours, and 7 hours 20 minutes is 7.33 hours.
| Minutes | Hours |
|---|---|
| 1 | 0.02 |
| 2 | 0.03 |
| 3 | 0.05 |
| 4 | 0.07 |
| 5 | 0.08 |
| 6 | 0.10 |
| 7 | 0.12 |
| 8 | 0.13 |
| 9 | 0.15 |
| 10 | 0.17 |
| 11 | 0.18 |
| 12 | 0.20 |
| 13 | 0.22 |
| 14 | 0.23 |
| 15 | 0.25 |
| Minutes | Hours |
|---|---|
| 16 | 0.27 |
| 17 | 0.28 |
| 18 | 0.30 |
| 19 | 0.32 |
| 20 | 0.33 |
| 21 | 0.35 |
| 22 | 0.37 |
| 23 | 0.38 |
| 24 | 0.40 |
| 25 | 0.42 |
| 26 | 0.43 |
| 27 | 0.45 |
| 28 | 0.47 |
| 29 | 0.48 |
| 30 | 0.50 |
| Minutes | Hours |
|---|---|
| 31 | 0.52 |
| 32 | 0.53 |
| 33 | 0.55 |
| 34 | 0.57 |
| 35 | 0.58 |
| 36 | 0.60 |
| 37 | 0.62 |
| 38 | 0.63 |
| 39 | 0.65 |
| 40 | 0.67 |
| 41 | 0.68 |
| 42 | 0.70 |
| 43 | 0.72 |
| 44 | 0.73 |
| 45 | 0.75 |
| Minutes | Hours |
|---|---|
| 46 | 0.77 |
| 47 | 0.78 |
| 48 | 0.80 |
| 49 | 0.82 |
| 50 | 0.83 |
| 51 | 0.85 |
| 52 | 0.87 |
| 53 | 0.88 |
| 54 | 0.90 |
| 55 | 0.92 |
| 56 | 0.93 |
| 57 | 0.95 |
| 58 | 0.97 |
| 59 | 0.98 |
| 60 | 1.00 |
How it's worked out
Both times are turned into minutes after midnight and the start is taken from the end. If the end is earlier than the start, the shift runs past midnight, so 24 hours are added. Then the unpaid break is taken off. Decimal hours are the total minutes divided by 60, rounded to two places.
A day shift with a break
8:30 AM to 5:15 PM is 17:15 − 8:30 = 8 hours 45 minutes. Take off a 30-minute break and you get 8 hours 15 minutes, which is 8.25 hours (15 ÷ 60 = 0.25).
An overnight shift
10:00 PM to 6:30 AM: the end is earlier than the start, so add 24 hours to it. 30:30 − 22:00 = 8 hours 30 minutes. With a 45-minute break, that is 7 hours 45 minutes, or 7.75 hours.
A week with overtime
Say you work 45 hours at $20 an hour with the overtime option on. The first 40 hours pay 40 × $20 = $800. The other 5 hours are paid at 1.5 × $20 = $30, so 5 × $30 = $150. Gross pay for the week is $950.
Pay is worked out from the exact minutes, not the rounded decimal, so it can differ by a cent from multiplying the rounded hours yourself.
Calculating hours in Excel or Google Sheets
With the start time in A2 and the end time in B2:
Hours worked, formatted as [h]:mm:
=B2-A2Hours worked as a decimal (format the cell as a number):
=(B2-A2)*24A shift that may run past midnight, in decimal hours:
=MOD(B2-A2,1)*24Less an unpaid break in minutes in C2, in decimal hours:
=(MOD(B2-A2,1)-C2/1440)*24Add up a week of [h]:mm results with =SUM(D2:D8) and keep the [h]:mm format, so a total over 24 hours shows as 40:00 rather than 16:00. These formulas work the same in Excel and Google Sheets.
Related tools
Frequently asked questions
How do I calculate hours worked?
Take the start time from the end time, then subtract any unpaid breaks. For example, 8:30 AM to 5:15 PM is 8 hours 45 minutes; less a 30-minute lunch, that is 8 hours 15 minutes, or 8.25 hours. For a week, add up each day.
How do I convert minutes to decimal hours?
Divide the minutes by 60. 15 minutes is 0.25 hours, 30 minutes is 0.5 and 45 minutes is 0.75. So 7 hours 20 minutes is 7 + 20 ÷ 60 = 7.33 hours when rounded to two decimal places.
How are overnight shifts handled?
When the end time is earlier than the start time, the calculator treats the end as the next day. A shift from 10:00 PM to 6:30 AM is 8 hours 30 minutes. In the timesheet, the hours count toward the day the shift started.
How do I calculate hours between two times in Excel or Google Sheets?
Put the start time in A2 and the end time in B2. =B2-A2 formatted as [h]:mm gives hours and minutes, and =(B2-A2)*24 gives decimal hours. For shifts that cross midnight, use =MOD(B2-A2,1)*24.
How is overtime pay worked out?
With the overtime option on, the first 40 hours of the week are paid at your hourly rate and any hours beyond 40 at 1.5 times that rate. 45 hours at $20 is 40 × $20 + 5 × $30 = $950. This is the US federal FLSA rule for non-exempt employees; state rules can differ.
Should I include my lunch break?
Enter only unpaid breaks. The calculator subtracts the break minutes from the time between start and end. If your breaks are paid, leave the break at 0.