» Adding Time Values
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem: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:
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Adventure Capitalist: The Ultimate Road Trip
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
No comments have been submitted.

