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:
=C4+TIME(5,30,0)
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:
=TIME(14,30,30)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)