» Calculating Absolute Difference between Two Time Values
Columns A & B contain pairs of time values from the same day.
We want to create a formula that always subtracts the earlier time from the later one, regardless of which column each is in.
Use the IF function as shown in the following formula:
Use the ABS function as shown in the following formula:
Note: Apply hh:mm format to cells containing the formulas.