» Subtracting Times
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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:
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Business Plans For Dummies®
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Microsoft PowerPoint Version 2002 Step by Step
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
