Calculating times in excel

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
0
coan.jim (2)
3/21/2012 6:39:02 PM
excel 39879 articles. 2 followers. Follow

1 Replies
1940 Views

Similar Articles

[PageSpeed] 18

On Mar 21, 2:39=A0pm, Jimbo <coan....@gmail.com> wrote:
> I want Multiple if Statements Based upon the value in Cell AA (value is n=
umberic 1-5).
>
> Here is the start of my formula...
>
> =3DIFERROR(IF($AA$2=3D1,(X18>R18)&TEXT(ABS(X18-R18),"hh:mm"),IF($AA$2=3D2=
,(X18>F1=AD8)&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 ti=
me greater than 24 hours.
>
> Any to calculate this?

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
0
puppet_sock (108)
3/23/2012 6:28:56 PM
Reply:

Similar Artilces: