Forum Discussion
Time Differences Negative and Positive
Hi, I am wondering if there is a way to change negative numbers in Excel to positive numbers, but also keep the already positive numbers that are there. I am calculating the time between an...
Not sure what you'd like to calculate, but if answer literally
=IF(M3=M2,SIGN(K3-L2)*(K3-L2)*96,"")ABS on entire formula returns an error in case of empty string.