=IF(D7E7,D7,E7)+TIME(0,0,20)
Assuming D7 and E7 are stored as time and not text.

wrote in message
...
I have received 4 different formulas from 4 different
people and none have worked so far. I'm beating my head
off the wall! I've gone through the help menu and the
book but I still can't get this to work. It would seem
like a simple enough formula. Guess not.
I hate office "97"!
Anyone have any ideas?

Chris

-----Original Message-----

Your If is ok. To add the 20 seconds, type 0:20 into a
separate cell and add the cell reference to the formula.

For example, put 0:20 in G1 then use the formula:
=IF(D7<E7,D7,E7)+$G$1

HTH
Helen


-----Original Message-----
I need some help using "IF" syntax in Excel "97."
I want to compare the value(values are minutes&seconds)
in
one cell with another cell
and depending on which cell has the greater value I
would
like value displayed in a cell.
Example:

Cell D7 Cell E7
33:15 32:05

Cell C7 should display the greater of the two values.
I would also like Cell C7 to add 20 seconds to the
inserted value. I just can't figure this out; here is
the
formula I created
=IF(D7<E7,D7,E7)+20
But it doesn't work.

Chris

.

.