Why doesn't this work "=IF(C2= "13:00",C2+"16:00",C2+"4:00")
=IF(C2=--"13:00:00",C2+"16:00:00",C2+"04:00:00")
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"baz" wrote in message
...
in this configuration the "=" gives the opposite answer, other operators
also give wrong answers.
|