» 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:
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Marketing Plan: A Handbook with Marketing Plan
- Guide to Financial Reporting and Analysis
- Microsoft Windows XP Step by Step (With CD-ROM)
- Not-for-Profit Accounting Made Easy
No comments have been submitted.
