» Calculating Absolute Difference between Two Time Values
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Columns A & B contain pairs of time values from the same day.
We want to create a formula that always subtracts the earlier time from the later one, regardless of which column each is in.
Solution 1:
Use the IF function as shown in the following formula:
=IF(B2>=A2,B2-A2,A2-B2)
Solution 2:
Use the ABS function as shown in the following formula:
=ABS(B2-A2)
Note: Apply hh:mm format to cells containing the formulas.
Book Store:
Recommended Books:
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Marketing Plans
- Excel 2002 For Dummies®
- Learn MS Excel 2002 VBA/XML Programming
No comments have been submitted.


