» 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 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:
- Absolute Beginner's Guide to Microsoft Excel 2002
- Adventure Capitalist: The Ultimate Road Trip
- Now, Discover Your Strengths
- Getting to Yes: Negotiating Agreement Without Giving In
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Marketing Planning for Services
calculating time in ms excel
bhalchandra2000
how to calculate time in excel from yesterdays 13:15:00 to tadays 11:25:00.

