» Totaling Time Values
CATEGORY - Excel Time
VERSION - All Microsoft Excel Versions
Excel uses serial values to recognize time. The time's serial number is between 0 and 1 (noon serial time = 0.50).The time format to display hours, minutes and seconds is HH:MM:SS. For example, a time of 14 hours and 56 minutes is displayed as 14:56:00.
Problem:
The default time format does not allow a time value to exceed 24 hours. For example, by entering a time of 28:56:00, the result is 04:56:00.
Solution:
Change the format of the cell by placing brackets around the hour, [HH]:MM:SS. The result is displayed as 28:56:00.
In the screenshot below, cell C5 uses the SUM function in a formatted cell to sum times correctly.
Book Store:
Recommended Books:
- The 22 Immutable Laws of Branding
- Getting to Yes: Negotiating Agreement Without Giving In
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Accounting the Easy Way
- The Interpretation of Financial Statements
- The Financial Numbers Game: Detecting Creative Accounting Practices
No comments have been submitted.
