Tip Printed from ExcelTip.com

---

Subtracting Times


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