Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

How do I sum time values?

Posted by David Price on July 07, 2001 12:13 PM
I have a number of formulas that calculate the difference between two times of the day. The cells are formatted to produce the result in hours and minutes.
When I put a sum formula at the end of the row to add these times it will add the first two and then it seems to revert to a smaller number. I think that it is adding the time value not the actual hours and minutes.
Thank you in advance for your help
David P.

Re: How do I sum time values?

Posted by Aladin Akyurek on July 07, 2001 12:23 PM
You need to custom format the cell where you sum times values as

[h]:mm

Aladin


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.