I'm trying to make an excel formula that subtracts two times from one another to keep track of how long certain job functions are taking around here. 99% of the time the one cell is going be a later time then the other, but I want to make sure it catches the other %1 where the opposite is true.
basically im trying to figure out this
if c5 > d5 then subtract c5-d5, otherwise just do d5-c5
99% of the the it will be d5-c5 but I don't know how to make sure it catches the opposite situation.
sorry if this is confusing.
I tried it on my own but it keeps displaying ####### whenever the rare case takes place.
basically im trying to figure out this
if c5 > d5 then subtract c5-d5, otherwise just do d5-c5
99% of the the it will be d5-c5 but I don't know how to make sure it catches the opposite situation.
sorry if this is confusing.
I tried it on my own but it keeps displaying ####### whenever the rare case takes place.
Facebook
Twitter