» 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 an IF statement to determine which of the two values is the "earliest", and then subtract accordingly:
=B2-A2+IF(A2>B2,1)
Example:
Time1___Time2____Result
10:00___17:00____7:00
17:00___9:00_____16:00
12:00___15:00____3:00
Book Store:
Recommended Books:
- Financial Reporting and Analysis (2nd Edition)
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- The Analysis and Use of Financial Statements
- Microsoft Office XP Introductory Concepts and Techniques
- Now, Discover Your Strengths
- Absolute Beginner's Guide to Microsoft Excel 2002
No comments have been submitted.
