» 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:
- The Ernst & Young Business Plan Guide
- Financial Modeling - 2nd Edition
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Finance and Accounting for Nonfinancial Managers
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
No comments have been submitted.
