Add Time Calculator

How to use the Add Time Calculator

What this calculator does

This calculator adds independent time intervals and expresses the same total in the unit you choose. It is useful for work logs, study blocks, project tasks, training sessions, travel segments, media runtimes, and similar duration totals. Every valid row is converted to seconds, summed, and then converted to the selected Result unit. The calculation is about elapsed duration, not a clock-of-day or calendar date, so it does not account for time zones, daylight-saving transitions, leap seconds, or a particular month's actual length.

For technical context, the NIST Guide to the SI lists the standard relationships for minutes, hours, and days: 1 minute equals 60 seconds, 1 hour equals 3,600 seconds, and 1 day equals 86,400 seconds. Those exact factors are used here. Longer calendar-like units are explicitly treated as fixed average durations so that the addition remains deterministic.

When to use it

• Add a week of shift durations, billable time, or study sessions when each item was recorded separately.
• Combine mixed units such as 90 minutes, 2.5 hours, and 0.25 day without converting them by hand.
• Convert a total duration into seconds, hours, days, or another supported unit for reporting or spreadsheet work.
• Audit how much each time entry contributes to the overall total using the Entry breakdown table.

How to calculate

1. The calculator opens with a complete demonstration workweek: 5 h 30 min, 6 h 15 min, 4 h 45 min, 5 h 55 min, and 7 h 35 min. The first result is 30 hours, and a validated example XLSX workbook is available immediately.
2. Replace any Time value with your duration. Leave its Unit at h · min · sec for entries such as “1 h 50 min” or “45 min 20 sec.” If you choose a scalar unit such as Hours or Minutes, enter one nonnegative decimal number such as “2.5” or “90”.
3. Use Add another time to create more rows, up to 20 total. Remove rows you do not need. Blank rows are ignored, but a nonblank malformed row is rejected and excluded until corrected.
4. Change Result unit at any time. This converts the already-computed total without altering the source entries. Read Total duration for the selected presentation, then use Total seconds, Decimal hours, Included entries, and Average duration for cross-checking.
5. Select Download Excel to create a fresh workbook from the current validated controls. The workbook contains Summary, Inputs, and Breakdown sheets with typed numeric cells. Reset is intentionally different from startup: it clears the demonstration data, leaves two blank rows in the neutral h · min · sec mode, clears results, and disables export until at least one complete valid duration is entered again.

Input guide

Time 1, Time 2, and any added Time rows are duration inputs. In h · min · sec mode, they are required only if you want that row included and must contain one or more recognized components such as 3 h 37 min, 44 min, or 12.5 sec. Hours may exceed 24 because these are durations, not clock times. Minutes and seconds may also exceed 59; they are normalized through seconds. Negative values, scientific notation, unsupported text, duplicated unit tokens, and ambiguous comma-decimal forms are rejected rather than silently reinterpreted.

Unit 1, Unit 2, and each added Unit determine how the adjacent value is parsed. Scalar choices accept a U.S.-style decimal number with an optional correctly placed thousands separator. The exact short-unit factors are nanosecond = 10⁻⁹ second, microsecond = 10⁻⁶ second, millisecond = 10⁻³ second, minute = 60 seconds, hour = 3,600 seconds, day = 86,400 seconds, week = 7 days, and fortnight = 14 days. Months use 30.44 days and average years use 365.25 days, matching the stated average-duration assumptions. Decades, centuries, and millennia scale that average year; Leap years use exactly 366 days.

Result unit is a required display control. It does not change the underlying total; it only changes its representation. The h · min · sec result is normalized into whole hours and minutes plus seconds, while scalar units show a decimal value. A common mistake is to read an average month or year conversion as a calendar-date calculation. It is not: adding one “month” here means adding exactly 30.44 days, regardless of which month is on a real calendar.

Output guide

Total duration is the primary sum in the selected Result unit. Total seconds is the canonical aggregate used internally; it is especially useful for checking conversions. Decimal hours divides total seconds by 3,600. Included entries counts only nonblank, valid rows. Average duration divides total seconds by Included entries and formats that mean as h · min · sec. The header pills repeat the entry count, decimal-hour total, and current result format for fast scanning.

The Entry breakdown table has five columns: Entry identifies the row; Entered value preserves the user-facing input; Input unit names the parsing mode; Seconds shows that row after conversion to the canonical base; and Share of total shows the row's proportion of the positive total. A zero-duration row is valid and displays a 0% share when the overall total is positive. If the entire valid total is zero, shares display as 0% rather than implying a division by zero.

Worked example

The startup example adds 5 h 30 min + 6 h 15 min + 4 h 45 min + 5 h 55 min + 7 h 35 min. Adding the hour components gives 27 hours. Adding the minute components gives 180 minutes, and 180 minutes ÷ 60 = 3 hours. Therefore the exact total is 30 h 0 min 0 sec, which equals 108,000 seconds and 30 decimal hours. With five included entries, the average is exactly 6 h 0 min 0 sec. The first-open controls, result cards, breakdown, and XLSX checkpoints all use this same example.

Learn more

The Bureau International des Poids et Mesures explains the SI definition of the second, the base unit used for every conversion in this calculator. For additional writing and conversion conventions, see the NIST guidance on using SI units.