How to Add Hours, Minutes and Seconds to a Time in Excel?

Spread the love

In this post, you will learn how to add hours, minutes and seconds to a time in excel.

Adding hours, minutes, or seconds to a time –

Because time values are nothing more than a decimal extension of the date serial number
system, you can add two time values together to get a cumulative time value. In some
cases, you may want to add a set number of hours and minutes to an existing time value. In
these situations, you can use the TIME function.

Cell D4 in Figure below contains this formula:


In this example, we’re adding 5 hours and 30 minutes to all of the times in the list.

The TIME function lets you build a time value on the fly using three arguments: hour, min-
ute, and second. For example, this formula would return the time value 2:30:30 PM:


To add a certain number of hours to an existing time value, simply use the TIME function
to build a new time value and then add them together. This formula adds 30 minutes to the
existing time, resulting in a time value of 3:00 PM:

="2:30:00 PM" + TIME(0, 30, 0)

Rating: 1 out of 5.

Leave a Reply