Sometimes one of the columns has no data entered, it may be missing the date
and time and so when I drag the formula down column E ....it will give me a
value error. Is there a way for this cell to remain blank if there is no
data to calculate??

"ferde" wrote:

Thank you sooo much ... it works great . You saved me so much time.

Deb

"Toppers" wrote:

=A1+B1<C1+D1

"ferde" wrote:

A B C D E
03/27/2007 11:49 03/27/2007 16:47 True
03/27/2007 21:30 03/27/2007 20:00 False

I'm trying to find out the formula for column E.

I want to determine if the date and time in column A+B is less than the
date and time in Column C+D.

Thank you in advance for your time and help.
Deb