Calculating times in excel

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
 
P

Puppet_Sock

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?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top