» 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:
- Microsoft Outlook 2002 for Dummies
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Microsoft Excel Version 2002 Step by Step
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
No comments have been submitted.
