ExcelBanter - Why doesn't this work "=IF(C2= "13:00",C2+"16:00",C2+"4:00")

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Why doesn't this work "=IF(C2= "13:00",C2+"16:00",C2+"4:00") (https://www.excelbanter.com/excel-worksheet-functions/69114-why-doesnt-work-%3Dif-c2-%3D-13-00-c2-16-00-c2-4-00-a.html)

baz

Why doesn't this work "=IF(C2= "13:00",C2+"16:00",C2+"4:00")

in this configuration the "=" gives the opposite answer, other operators
also give wrong answers.

Bob Phillips

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.

All times are GMT +1. The time now is 03:09 AM.