Home

Adding Hours, Minutes, or Seconds to a Time in Excel

By
No items found.
Updated
2016-03-26 10:53:38
From the book
No items found.
Share
Microsoft 365 Excel For Dummies
Microsoft 365 Excel For Dummies book cover
Explore Book
Subscribe on Perlego
Microsoft 365 Excel For Dummies
Microsoft 365 Excel For Dummies book coverExplore Book
Subscribe on Perlego

Because time values are nothing more than a decimal extension of the date serial numbering 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 4-20 contains this formula:

=C4+TIME(5,30,0)

In this example, you add 5 hours and 30 minutes to all the times in the list.

image0.jpg

The TIME function allows you to build a time value on the fly using three arguments: hour, minute, and second.

For example, the following formula returns the time value 2:30:30 p.m.:

=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. The following formula adds 30 minutes to the existing time, resulting in a time value of 3:00 p.m.

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

About This Article

This article is from the book: 

No items found.

About the book author:

No items found.
No items found.