» 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:
- Positioning: The Battle for Your Mind
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Understanding Financial Statements
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- The Total Money Makeover. : A Proven Plan for Financial Fitness
No comments have been submitted.
