To calculate the absolute differences, you
just need one of below formulas, paste one of below formulas to the
blank cell you want to place the result, press Enter key, and drag fill handle over cells needed this formula.
=ABS(A2-B2)
=IF(B2>=A2,B2-A2,A2-B2)
Note: if you want to calculate the absolute difference between times, you only can apply =ABS(A2-B2) and then format values as time
No comments:
Post a Comment