FLXCode Time Calculator

FLXCode apps

Appearance

Time Calculator

Add up hours, minutes and seconds in as many rows as you need. Or start from a time of day, add or take away a duration and read the end time.

Example Total time

3:55:30
  • Hours, minutes, seconds3:55:30
  • In words3 hours, 55 minutes, 30 seconds
  • Decimal hours3.93
  • Total minutes235.50
  • Total seconds14,130

How it was worked out

  1. + 2:30:00 gives a running total of 2:30:00
  2. + 1:45:30 gives a running total of 4:15:30
  3. - 0:20:00 gives a running total of 3:55:30
  4. The parts add to 3 h, 55 min, 30 s. Carrying 60 seconds into minutes and 60 minutes into hours gives 3:55:30.

No ads. No account. Nothing you type or record is uploaded. We count page events with a daily code. Check it.

Problem or idea? Email us

Quick start

  1. Pick Add up durations to get a total, or Clock time plus durations to get an end time.
  2. Type hours, minutes and seconds in a row. Leave a box empty for 0. Choose Add or Subtract for the row.
  3. Press Add a row for more. The result updates as you type.
  4. In clock mode, type the start time such as 10:30 PM or 22:30 and choose the 12 or 24 hour clock for the answer.

Worked examples: durations

SumResultIn wordsNote
1:15:40 + 0:48:202:04:002 hours, 4 minutesTwo video clips
2:30:00 + 1:45:30 - 0:20:003:55:303 hours, 55 minutes, 30 secondsAdd two, take one away
8:00:00 - 2:45:305:14:305 hours, 14 minutes, 30 secondsTime left in a shift
0:45:30 + 0:30:451:16:151 hour, 16 minutes, 15 secondsSeconds carry into minutes
0:50:00 + 0:50:00 + 0:50:00 + 0:50:003:20:003 hours, 20 minutesFour 50-minute sessions
1:00:00 - 1:30:00-0:30:00-30 minutesA negative result

Worked examples: a time of day plus a duration

StartChangeEnd timeNote
9:00 AM+ 8:30:005:30 PMA workday
10:30 PM+ 3:45:002:15 AM (+1 day)A late film
6:00 AM- 7:30:0010:30 PM (-1 day)Back before midnight
23:45+ 9:20:0009:05 (+1 day)An overnight train
6:00 PM+ 54:00:0012:00 AM (+3 days)A 54 hour trip

How the sum is done

  1. Every row turns into seconds: hours times 3,600, plus minutes times 60, plus seconds.
  2. Rows set to Subtract count as negative. All rows are added into one number of seconds.
  3. That number goes back to hours, minutes and seconds. 4,575 seconds is 1 hour (3,600), 16 minutes (960) and 15 seconds.
  4. In clock mode the start time is also in seconds after midnight. The total is added to it, then divided by 86,400. The whole part is the day shift and the remainder is the time of day.

Because it is all whole seconds, there is no rounding until the decimal hours, so the h:mm:ss answer is exact.

Numbers this uses

  • 60 seconds in a minute, 60 minutes in an hour, 24 hours in a day, so 86,400 seconds in a day.
  • Decimal hours: seconds divided by 3,600, rounded to 2 decimals, half up (1 minute is 0.0167 and shows 0.02).
  • Total minutes: seconds divided by 60, with up to 2 decimals.
  • Rows: up to 12. Each box is a whole number up to 7 digits, and one row is limited to a million hours.
  • A time of day without AM or PM is read as a 24 hour time in 24 hour mode. In 12 hour mode the start is read as AM and the tool says so.

In Excel or Google Sheets

TaskFormula
Total of durations in A1 to A4=SUM(A1:A4), cell format [h]:mm:ss
Time of day plus a duration=A1+B1, cell format h:mm AM/PM
Keep the time of day after midnight=MOD(A1+B1,1)
Hours, minutes and seconds into a duration=TIME(A1,B1,C1) (hours above 23 wrap, use =A1/24+B1/1440+C1/86400 instead)
Duration in A1 as decimal hours=A1*24

Limits

  • This is clock arithmetic with no time zone and no daylight saving. On the night the clocks change, the real elapsed time is an hour more or less than the clock says.
  • To count hours worked over a week with breaks, use the Hours Calculator. To measure the gap between two times, use the Time Duration Calculator.
  • For the same moment in other places, there is a Time Zone Converter.

Nothing you type is uploaded. We count events without cookies (details).

FAQ

How do I add hours and minutes?

Add the hours to the hours and the minutes to the minutes. If the minutes come to 60 or more, move each full 60 into one extra hour. 2 h 45 min plus 1 h 30 min is 3 h 75 min, which is 4 h 15 min. Type each time in its own row and the tool does the carrying and shows it.

How do I add or subtract time to a clock time?

Switch to Clock time plus durations, type the start time, then add or subtract the rows. 10:30 PM plus 3 h 45 min is 2:15 AM, and the tool marks it +1 day because it passed midnight.

What does +1 day mean next to the end time?

The end time falls on the next calendar day. -1 day means the day before the start day, and a longer span shows +2 days and so on. The time itself is always between 12:00 AM and 11:59 PM.

Can I get the answer in decimal hours?

Yes. Every result also shows decimal hours with 2 decimals, so 1 h 16 min 15 s is 1.27. The minutes are divided by 60 and the value is rounded to the nearest hundredth, half up.

How do I subtract time and what if the answer is negative?

Set the row to Subtract. If you take away more than you added, the result is negative and shown with a minus sign, for example -0:30:00, and the tool says so. Nothing is wrapped around to the previous day unless you are in clock mode.

How do I add up time in Excel or Google Sheets?

Put each duration in a cell as h:mm:ss and add them with =SUM(A1:A4). Format the total as [h]:mm:ss, with the square brackets, or the sheet will drop whole days and show only the part after 24 hours. To subtract use =A1-B1.

Is there a limit on the hours?

No cap at 24. 40 hours is shown as 40:00:00 and also written as 1 day, 16 hours. Each box takes a whole number up to 7 digits, and one row can hold up to a million hours.

Is what I type uploaded or saved?

No. The sums run in your browser. Nothing you type goes into the address bar, storage or the counts we keep. We only count that a calculation was made and which mode it used.

More from FLXCode

Share Time Calculator