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...
Kay_T1060 , Hi, function ABS changes negative no. to positive but keeps positive nos. positive. So say, =ABS(-3) = 3 and =ABS(3) = 3 as well
In your case, it would bedone like =ABS(IF(M3=M2,(K3-L2)*96,""))
Hopefully that solves your issue (and if i understood your problem statement correctly)