Windows  |  Free Downloads

 

 

 

Adding or Summing Time in Microsoft Excel

The biggest problem people encounter when they try to add time values is incorrect formatting of the results cell.

In our demonstration, both A1 and B1 are automatically formatted as time. A simple sum formula works fine at this point to provide a total of 4 hours.

Things change drastically when we try to add 12.5 hours to 12.5 hours, we only get a result of 1 hour.

That's because it's adding the time of day, and not hours. So if you add 12.5 hours to 12:30 on the clock, it's now 1:00 am. You wanted a result of 25 hours.

In the following demonstration, the resulting cell is formatted to properly add the hours. Note the square brackets around the hour format. If desired, just delete the last 3 characters in the Type box so you don't see the seconds values.

The only thing I've changed is the format of the resulting cell:

 

Back to top...

OfficeArtilces.com debuted on May 26, 2005.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2014 by MrExcel Consulting | All rights reserved

privacy policy