I'm subtracting time (y2-z2) and in some cases it should be a negative number. It will change, however, depending on data entered in. So i need one formula that will display the actual time whether the number is positive or negative.
I found this from a different website: =IF(Y2<Z2,"-","")&TEXT(ABS(Y2-ZZ2),"hh:mm:ss") but when the # is positive it just returns the value in y2.
any help?
Thanks!
Ian
Bookmarks