View Single Post
  #1  
Old June 3rd, 2010, 07:44 PM posted to microsoft.public.excel.worksheet.functions
Teri
external usenet poster
 
Posts: 155
Default Determine "on time" status

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