HoursTools
  1. Home
  2. Time Duration Calculator

Form No. 09 · Time arithmetic

Time Duration Calculator

Add up or take away lengths of time in hours and minutes — 7:45 plus 8:30 minus 1:15 — or work out what time it will be a set number of hours after a start time.

HoursTools · No. 09Time adder
Calculation

Type 7:45, 7h 45m, 45m or decimal hours like 7.75.

Total
Hours : minutes0:00
Decimal hours0.00
Total minutes0

How to use the time duration calculator

Add / subtract times works like an adding machine for hours and minutes. Put one length of time on each line, choose whether it is added or subtracted, and the total appears below in three forms: hours and minutes, decimal hours and plain minutes. Add as many lines as you like.

Clock time ± duration answers “what time will it be?” Enter a start time, choose add or subtract, and type the length. If the result crosses midnight, the calculator says how many days it moved — handy for finding when a 12-hour shift ends or when a 36-hour cure, charge or rest period is up.

Durations can be typed several ways: 7:45, 7h 45m, 45m, or decimal hours such as 7.75. Hours aren’t limited to 24, so 38:15 is fine.

Why time doesn’t add like ordinary numbers

Hours run on base 60. Typed into a normal calculator, 7.45 + 8.30 gives 15.75, which looks like 15 hours 75 minutes — a time that doesn’t exist. The reliable method is to convert everything to minutes, do the arithmetic, then convert back.

Minutes = hours × 60 + minutes Total = sum of added minutes − sum of subtracted minutes Hours = total ÷ 60, whole part Minutes = total − hours × 60 Decimal = total ÷ 60

For the clock mode, the duration in minutes is added to the start time’s minutes after midnight. Every 1,440 minutes is one day; whatever is left over is the clock time on the final day.

Worked examples

Fixing a timesheet. A supervisor has a week recorded as 38:45, finds a missed 2:30 on Thursday, and has to take off 0:45 for a long lunch that was logged as work.

38:45 = 2,325 min + 2:30 = 150 min − 0:45 = 45 min Total = 2,430 min = 40 hours 30 minutes = 40.50 hours

The corrected week is 40:30 — just over 40, so half an hour of overtime for a non-exempt employee.

When does the shift end? A 9 hour 30 minute shift starts at 9:45 PM. 9:45 PM is 1,305 minutes after midnight; adding 570 minutes gives 1,875. Taking away one day (1,440) leaves 435 minutes, which is 7:15 AM the next day.

Common time-math mistakes

  • Reading decimals as minutes. 7.5 hours is 7 hours 30 minutes, not 7 hours 50 minutes. 0.1 hour is 6 minutes.
  • Subtracting across midnight. 2:00 AM minus 10:00 PM isn’t −20 hours; it’s 4 hours the next morning. Use clock mode or the hours calculator, which handles the day change.
  • Spreadsheets wrapping at 24 hours. In Excel or Google Sheets, a total of 26:30 formatted as a time shows 2:30. Use the custom format [h]:mm to show totals past 24 hours.
  • Rounding each line. If every line is rounded to a decimal before adding, the errors pile up. Add in minutes and convert once.

Where people use it

Payroll and timesheet corrections, totalling billable time across several jobs, adding up flight or drive legs, working out how long is left in a study or training requirement, and planning back-to-back shifts with a minimum rest period between them. For converting a total into payroll decimals, the decimal hours converter has a full minute-by-minute table.

Questions people ask

How do I add hours and minutes together?

Convert each time to minutes (hours × 60 + minutes), add them up, then divide by 60. The whole number is hours and the remainder is minutes. 2:45 + 1:30 is 165 + 90 = 255 minutes, which is 4 hours 15 minutes.

How do I subtract one time from another?

Convert both to minutes and subtract. 8:15 − 3:40 is 495 − 220 = 275 minutes, or 4 hours 35 minutes. If you are subtracting clock times across midnight, add 24 hours to the later time first.

What time is it 8 hours from now?

Use clock mode: enter the current time, choose Add and type 8:00. The result shows the time and whether it falls on the next day.

How do I show more than 24 hours in Excel?

Format the total cell with the custom number format [h]:mm. Without the square brackets Excel restarts the count every 24 hours.

Sources