Not sure what you mean by AM/PM; is there another way to format other than
how they are written in my example?

"Tom-S" wrote:

Assuming you have the date-times in N6 and O6, and that these cells are
formatted as dd-mmm-yy hh:mm AM/PM, then your formula should work. I just
tried it out and it seemed ok to me.

Post again if your formats are ok.

Regards,

Tom


"Teri" wrote:

I'm trying to write a formula to determine if a delivery is on time. In the
example below, I used =IF(O6=N6,"Yes","No") and Excel returned "No", but
this shipment was on time. What am I doing wrong?

Column N Column O
Scheduled Delivery Date / Time Actual Delivery Date / Time
25-May-10 05:00 PM 25-May-10 09:00 AM