in this configuration the ">=" gives the opposite answer, other operators also give wrong answers.
B baz Feb 2, 2006 #1 in this configuration the ">=" gives the opposite answer, other operators also give wrong answers.
B Bob Phillips Feb 2, 2006 #2 =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)
=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)
