Hours calculator
Hours between two times, a timesheet of hours worked, or a time plus hours. Results update as you type.
Hours between two times
Timesheet: hours worked
Add hours to a time
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 split shift
Some days have two shifts, such as 6:00 AM to 10:00 AM and 4:00 PM to 8:30 PM. Each shift is worked out on its own (4 hours and 4 hours 30 minutes) and the day total is the sum: 8 hours 30 minutes. The timesheet allows up to two shifts a day.
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.
Two weeks with overtime
Overtime is counted in each workweek on its own. If you work 45 hours in week 1 and 35 hours in week 2, that is 80 hours over the pay period but still 5 overtime hours, all from week 1. The federal rule does not let the short week cancel out the long one.
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. The timesheet above can also download a CSV file that opens in either.
Which calculator do you need?
- Time calculator: add and subtract hours, minutes and seconds, or a duration to a date and time.
- Time duration calculator: the time between two times or two dates and times.
- Hours calculator: hours worked, shifts, breaks and weekly or biweekly timesheets.
- Date duration: days, weeks and months between two dates.
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. Enter only unpaid breaks; if your breaks are paid, leave the break at 0.
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 and split shifts handled?
When the end time is earlier than the start time, the end is treated as the next day: 10:00 PM to 6:30 AM is 8 hours 30 minutes, and in the timesheet it counts toward the day the shift started. For a split shift, add a second shift to that day; the day total is the two shifts added together.
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, including biweekly pay?
With the overtime option on, hours over 40 in a workweek are paid at 1.5 times the hourly rate: 45 hours at $20 is 40 × $20 + 5 × $30 = $950. With two weeks, each week is counted separately, so 45 hours plus 35 hours still gives 5 overtime hours. This is the US federal FLSA rule for non-exempt employees; state rules can differ.
Is my timesheet saved, and can I print or export it?
With "Save in this browser" on, your entries are kept in this browser's local storage and come back when you return; they are not sent anywhere. Clear saved data removes them. Print gives a clean page with just the timesheet, and Download CSV saves a file you can open in Excel or Google Sheets.