View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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.