Adding hours and minutes together
- Line the times up: hours under hours, minutes under minutes.
- Add the minutes.
- If the minutes come to 60 or more, take off 60 and add 1 to the hours. Repeat until the minutes are below 60.
- Add the hours, including any you carried.
| Sum | Hours | Minutes | Carry | Answer |
|---|---|---|---|---|
| 2:45 + 3:20 | 5 | 65 | 65 = 1:05 | 6:05 |
| 8:30 + 7:45 | 15 | 75 | 75 = 1:15 | 16:15 |
| 1:35 + 2:50 + 0:55 | 3 | 140 | 140 = 2:20 | 5:20 |
| 3:00 + 0:93 | 3 | 93 | 93 = 1:33 | 4:33 |
The third row is a typical travel day: three flight legs of 1:35, 2:50 and 0:55 come to 5:20 in the air. The same method works for study sessions, practice time or hours on a project.
Clocktape is built for this: type 2:45 on one line and 3:20 on the next, and the tape total reads 6:05 without any carrying on your part. Get it on Google Play
Subtracting hours and minutes
Subtract the minutes first. If the top number of minutes is smaller, borrow one hour and add 60 to the minutes.
| Sum | Borrow | Answer |
|---|---|---|
| 8:10 − 2:45 | 8:10 = 7:70 | 7:70 − 2:45 = 5:25 |
| 44:15 − 40:00 | none needed | 4:15 |
| 17:15 − 8:30 | 17:15 = 16:75 | 16:75 − 8:30 = 8:45 |
Subtracting is also how you get the time between two clock times, such as a start and an end. If the end is after midnight, add 24 hours to it first; our page on calculating hours worked overnight shows the examples.
Totals over 24 hours
When you add up a week of work or a logbook of flights, keep the total in hours. 26:30 means 26 hours 30 minutes. Writing it as "1 day 2:30" is correct but harder to check against a timesheet, and multiplying a rate by it gets awkward.
Large totals work the same way. A long logbook might come to 1,284:35. To add another 2:40, add 40 minutes to 35 to get 75, carry 1 hour, and the new total is 1,287:15.
Adding hours, minutes and seconds
With seconds, carry twice: every 60 seconds becomes a minute, then every 60 minutes becomes an hour.
Example: 1:02:45 + 0:58:30. Seconds: 45 + 30 = 75, which is 1:15, so write 15 and carry 1 minute. Minutes: 2 + 58 + 1 = 61, which is 1:01, so write 1 and carry 1 hour. Hours: 1 + 0 + 1 = 2. The answer is 2:01:15.
Multiplying and dividing time
- Time × a number: 8:30 × 5 = 42:30. Work it out as 8 × 5 = 40 hours and 30 × 5 = 150 minutes, which is 2:30, giving 42:30.
- Time ÷ a number: 42:30 ÷ 5 = 8:30, the average day.
- Time ÷ time: 44:15 ÷ 8:00 gives a plain number, not a time. 44.25 ÷ 8 = 5.53, so 44:15 is about 5.5 eight-hour days.
Adding hours and minutes in Excel
- Type times with a colon, such as 2:45, so Excel stores them as time.
- Use
=SUM(A2:A8)to add them. - Format the total cell as
[h]:mm. Without the square brackets, a total of 26:30 shows as 2:30 because Excel wraps at 24 hours. - For a decimal result, multiply the sum by 24:
=SUM(A2:A8)*24.
Need the total as a decimal for a pay rate? Divide the leftover minutes by 60, or see our minutes to decimal hours chart.
Keep a running total you can fix
On a Clocktape tape every line has its own result, so changing one leg or one session updates the total straight away.
Get it on Google PlayiPhone version coming soon
More guides
- How to Calculate Hours Worked: Start, End, Breaks and Weekly TotalCalculate hours worked from start and end times: subtract, take off unpaid breaks, add the days, then convert to decimal hours. A full worked week included.
- How to Calculate Hours Worked Overnight (Shifts Past Midnight)When a shift ends after midnight, add 24 hours to the end time before subtracting. Night shift examples, breaks, splitting at midnight and spreadsheet formulas.
- Minutes to Decimal Hours: Formula and Conversion ChartConvert minutes to decimal hours by dividing by 60. Full chart from 1 to 60 minutes, the reverse conversion, rounding to 1, 2 or 3 places, and common time card mistakes.
- How to Calculate Overtime Hours from a Time CardOvertime hours are the hours worked beyond your threshold. Total the week in hours and minutes, subtract the threshold, convert to decimals, check daily and weekly rules.
Published by Zoranta, the developer of Clocktape.