Help with formula please

[ferde]

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

 

[Toppers]

=A1+B1<C1+D1

 

[ferde]

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

Deb

 

[ferde]

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??

 

[Toppers]

=IF(AND(A1+B1>0,C1+D1>0),A1+B1<C1+D1,"")

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]

WORKS GREAT.... you are the man

=IF(AND(A1+B1>0,C1+D1>0),A1+B1<C1+D1,"")