How to add hours, minutes and seconds in Excel

Excel Data Analysis For DummiesExplore Book Buy On AmazonSign up for the DummiesBeta Programto try Dummies' newest way to learn.By checking this box, you agree to the Terms of Use

How to add hours, minutes and seconds in Excel
Excel Data Analysis For Dummies

Explore Book Buy On Amazon

Sign up for the DummiesBeta Program
to try Dummies' newest way to learn.By checking this box, you agree to the Terms of Use and Privacy Policy & to receive electronic communications from Dummies.com, which may include marketing promotions, news and updates.Sign UpCancelOK

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:

  • Excel Data Analysis For Dummies ,

About the book author:

Paul McFedries is a true renaissance geek. He has been a programmer, consultant, database developer, and website builder. He's also the author of more than 90 books including top sellers covering Windows, Office, and macOS.

This article can be found in the category:

  • Excel ,

Video liên quan