J
Jimbo
I want Multiple if Statements Based upon the value in Cell AA (value is numberic 1-5).
Here is the start of my formula...
=IFERROR(IF($AA$2=1,(X18>R18)&TEXT(ABS(X18-R18),"hh:mm"),IF($AA$2=2,(X18>F18)&TEXT(ABS(X18-F18),"hh:mm"),X18-F18))," ")
The Columns R,X,F, are times. This appears to work work when X is a time after Column R & F, but if the time in X is prior to R & F, It give me a time greater than 24 hours.
Any to calculate this?
Thanks in advance
Here is the start of my formula...
=IFERROR(IF($AA$2=1,(X18>R18)&TEXT(ABS(X18-R18),"hh:mm"),IF($AA$2=2,(X18>F18)&TEXT(ABS(X18-F18),"hh:mm"),X18-F18))," ")
The Columns R,X,F, are times. This appears to work work when X is a time after Column R & F, but if the time in X is prior to R & F, It give me a time greater than 24 hours.
Any to calculate this?
Thanks in advance