Why clock arithmetic goes wrong
Time is base 60 for minutes and base 24 for hours, and a calculator that assumes base 10 gives confidently wrong answers. Three traps account for nearly every mistake:
- Treating minutes as hundredths. 7:45 plus 30 minutes is 8:15, not 8:75. Once minutes reach 60 they roll into an hour.
- Forgetting the day boundary. 22:00 plus 4 hours is 02:00 the next day, not 26:00. This tool tells you when the answer has crossed midnight and by how many days.
- Mixing clock times with durations. "9:30" as a moment and "9:30" as a length of time behave differently. Adding two clock times is meaningless; adding two durations is not.
The four operations
| Operation | Use it for | Example |
|---|
| Add time to a clock time | Finding when a shift ends, when a timer expires, an arrival time | 09:30 + 8h 30m = 18:00 |
| Subtract time from a clock time | Working backwards from a deadline or a departure | 17:00 − 45m = 16:15 |
| Add two durations | Totalling several tasks, shifts or billable blocks | 7h 45m + 3h 20m = 11h 05m |
| Subtract one duration from another | Time remaining against a budget or target | 40h − 32h 15m = 7h 45m |
Doing it by hand
Convert everything to minutes, do plain arithmetic, convert back. For 09:30 plus 8 hours 30 minutes:
- 09:30 → (9 × 60) + 30 =
570 minutes.
- 8h 30m → (8 × 60) + 30 =
510 minutes.
- 570 + 510 =
1080 minutes.
- 1080 ÷ 60 = 18 remainder 0 → 18:00.
- If the total had exceeded 1,440, subtract 1,440 and add a day.
In a spreadsheet
Excel and Google Sheets store a time as a fraction of a day, so one hour is 1/24. That makes the formulas short but unintuitive:
| Goal | Formula |
|---|
| Add 8 hours 30 minutes to A2 | =A2+TIME(8,30,0) |
| Add a number of hours in B2 | =A2+B2/24 |
| Keep the result inside one day | =MOD(A2+B2/24,1) |
| Add two durations and show over 24 h | =A2+B2 formatted as [h]:mm |
| Duration as decimal hours | =(A2+B2)*24 |
The [h]:mm format is the one people miss: without the square brackets a total of 30 hours displays as 6:00, because the format wraps at 24. If your weekly totals look impossibly small, that is almost always why.
Frequently asked questions
What time is 8 hours 30 minutes after 9:30?
18:00, or 6:00 PM. 09:30 is 570 minutes past midnight; adding 510 minutes gives 1,080, which is 18:00.
How do I add hours and minutes together?
Convert both to minutes, add them, then divide by 60 for hours and take the remainder as minutes. 7h 45m + 3h 20m = 465 + 200 = 665 minutes = 11h 05m.
What happens if the result goes past midnight?
The calculator wraps to the next day and tells you so. 22:00 plus 4 hours is 02:00 with a +1 day marker.
Can I subtract a bigger duration from a smaller one?
Yes — the result is shown as a negative duration, which is what you want when checking hours against a target you have not reached.
Why does my spreadsheet show 6:00 when the total is 30 hours?
The cell format wraps at 24 hours. Format it as [h]:mm with square brackets and it will display 30:00.
What is the difference between this and the hours calculator?
This page adds or subtracts a known amount of time. The hours calculator measures the gap between two clock times you already know.
Related tools and guides