Calculating times in excel

  • Thread starter Thread starter Jimbo
  • Start date Start date
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
 
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>F1­8)&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?
Click to expand...

Sorry dude. I am not going to try to puzzle out your incorrect formula
to try to guess your requirements in order to give you the correct
formula.

Can you write down what you want in words? See if you can explain it
without referring to cells or formats or if-then-else or any other
syntax.
Something like "When this one is bigger I want the difference between
those two" or some such.

Many computer problems are solved readily if you can clearly state
them.
Socks
 
Back
Top