View Single Post
  #7  
Old June 3rd, 2010, 10:16 PM posted to microsoft.public.excel.worksheet.functions
Tom-S[_2_]
external usenet poster
 
Posts: 68
Default Determine "on time" status

Pity. Can you tell us what format you have got applied to the columns N and O
where the date-times are stored?

Could you also on your sheet have 2 formulas (both in cells formatted as
number):
=N6 and =O6
and tell us what answer you get from these formulas.

Regards,

Tom


"Teri" wrote:

Thanks guys; I really appreciate your help. Neither of those suggestions
worked. The funny thing is, I have a row above and a row below the one in
question and they work fine. The difference is they were delivered in the PM
instead of the AM.

Scheduled Dely Date / Time Actual Dely Date / Time On / Time (Yes / No)
18-May-10 04:00 PM 18-May-10 03:36 PM Yes
25-May-10 05:00 PM 25-May-10 09:00 AM No
25-May-10 05:00 PM 24-May-10 02:40 PM Yes


"Dave Peterson" wrote:

I would try a couple of things.

First, give N6 and O6 an unambiguous date/time format.
Like:
mmmm dd, yyyy hh:mm:ss

If the values don't change, then your entries aren't really date and times.
They're just plain old text. You'll want to convert them to real dates/times.

If they do change to that nice format, then check the years. Maybe one of those
10's is 1910 and the other is 2010????

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


--

Dave Peterson
.