» Avoiding Errors When Subtracting Times
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
In order to calculate the difference between two time values, the earlier time must be subtracted from the later one.
However, when the later time refers to the following day (with respect to the earlier time), an error will result.
We want to create a formula that avoids these errors when calculating the difference between any two time values.
Solution:
Use the MOD function as shown in the following formula:
=MOD(B2-A2,1)
Note:
Apply hh:mm format to all cells containing the formula.

Book Store:
Recommended Books:
- Seven Habits Of Highly Effective People
- Investing in Real Estate, Fourth Edition
- Marketing Plan: A Handbook with Marketing Plan
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Microsoft Outlook 2002 for Dummies
No comments have been submitted.


