» Adding a Number to a Formatted Time Value
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Creating a formula that will return a time value which is the sum of the time in cell A2 and the number of hours in cell B2.
Solution:
When adding a time value and a number representing hours, we must first divide the number by 24, as shown in the following formula:
=A2+B2/24
Ensure that the result cell is formatted [hh]:mm to correctly display a time.
Book Store:
Recommended Books:
- Financial Statement Analysis with S&P insert card
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Microsoft Windows XP Inside Out
- Financial Reporting and Analysis (2nd Edition)
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Analyzing Markets, Products, and Marketing Plans
No comments have been submitted.

