Excel lets you work with all types of numbers. One example is time. Let’s learn how to add time in Excel.
There are several ways to add time in Excel. Let’s look at two common cases with real-world examples.
How to Add Times in Excel (To Find Total Time)
Imagine you’re booked on two flights. One lasts four hours and ten minutes; the second lasts two hours and twenty minutes. You want to know how long you’ll be in the air.
Working in Excel, type your first flight time into a cell: 4:10. In an adjacent cell, type in your second: 2:20.
It’s worth noting that you can leave the cell formatted as General, which is Excel’s default. The app is smart enough to recognize times formatted like this, and be able to add them correctly.
In a third cell, click and type = to begin a formula. Then, click the first time, insert a + sign, then click on the second time.
Here, your formula is:
=A1+A2
Hit Enter on your keyboard, and Excel will return your total duration: 6:30.
How to Add Times (With Time Formatting)
Similar, but slightly different ways to add time are possible. Consider this. If you start a task at 4:00 PM, and it takes three hours to complete, what time will you be finished?
Begin by typing 4:00 PM into a cell. Excel will recognize this as a time value. In the cell below, type in your task duration, formatted as 3:00.
Repeat the steps from before, adding the two cells together. Here, your formula will be:
=C1+C2
Hit Enter again, and Excel gives you the time of completion: 7:00 PM. Notice that, once again, your result will be formatted with the PM characters already included.
As you can see, adding time takes only seconds in Excel.