» Adding Time Values
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
When using a standard SUM formula to add the time values in column B (=SUM(B2:B5)), a false result of 4:23 is returned, rather than the actual sum of 28:23.
Solution:
Excel's default time format does not allow a time value to exceed 24 hours. This is the cause of the above error.
To properly display a sum exceeding 24 hours, change the format of the cell from "h:mm" to "[hh]:mm".
Book Store:
Recommended Books:
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Microsoft Office XP Introductory Concepts and Techniques
- Excel 2002 Power Programming with VBA
- Special Edition Using Microsoft Word 2002
- Investing in Real Estate, Fourth Edition
- Business Analysis with Microsoft Excel (2nd Edition)
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
