Kiran,

Can you have date AND time in column?
Assuming you have one in Col A and the other in Col B then in C2 you can enter
=If(A2B2,"Yes","No")

You can enter in F2
=A1+B1
and in G2
=C1+D1
to combine the date & time

Then your formula will become
=IF(F2G2,"Yes","No")

Let me know how it works out.

Makse sure that A & C have dates and D & E have times...
I had to retype the values provided by you as they did not automatically
convert to date in A & C

"kiran" wrote:

Dear All,

A B C D E
Date Time Date Time Output
04.07.08 9:18:56 AM 01.08.08 7:41:33 PM
04.08.08 9:18:56 PM 01.08.08 7:41:33 PM
24.08.08 10:05:03 AM 22.08.08 12:13:30 PM

Check date time in column A, B, C & D if date & time of column C & D is
greater that date time of column A & B I should get "No" else "Yes" in column
E.

TIA