» Subtracting Times
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem:Finding the interval between each pair of start and end times in columns A & B. An error occurs when the end time is "earlier" than the start time, resulting in a negative result.
Solution:
Use the IF function as shown in the following formula to determine which of the two values is the "earliest", and then subtract accordingly:
=B2-A2+IF(A2>B2,1)
Book Store:
Recommended Books:
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- How to Pay Zero Taxes (Annual)
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
No comments have been submitted.
