Thanks, Joeu2004, but I'm not sure how to enter your argument in my whole
formula. How would you do it?

"joeu2004" wrote:

On Nov 11, 10:00 am, johnthebaptist
wrote:
Excel tells me that E3=4 is FALSE, where E3=4:45, a time format, and
formatting should be ignored.

You will get some insight into the problem if you reformat the cell as
Number. Time is stored as fractions of a day. 4:45 is stored as
4.75/24. One solution:

E3=timevalue("4:00")