Prev: Splitting Text from single cell in column across multiple Columns
Next: Multiple IF function
From: Teri on 12 Mar 2010 17:25
I have two columns, one is Sched Dely Date/Time (O5) and the other is Actual
Dely Date/Time (N5).

If my Sched Dely Date / Time is 04-Mar-10 05:00 PM and the
Actual Dely Date / Time is 04-Mar-10 12:52 PM, the delivery would be on
time. But if I use the IF function of O5>N5 it give me a TRUE answer when in
fact it is FALSE. What would be the correct formula?
From: Fred Smith on 12 Mar 2010 18:03
Sorry, 5:00 pm is *after* 12:52 pm. 12:52 pm is just after noon, whereas
5:00 pm is five hours after it.

Excel is correct. A True answer means the delivery was on time (or, more
correctly, not late)

Regards,
Fred

"Teri" <Teri(a)discussions.microsoft.com> wrote in message
news:13959350-DFEA-428A-8833-191307DA9F92(a)microsoft.com...
>I have two columns, one is Sched Dely Date/Time (O5) and the other is
>Actual
> Dely Date/Time (N5).
>
> If my Sched Dely Date / Time is 04-Mar-10 05:00 PM and the
> Actual Dely Date / Time is 04-Mar-10 12:52 PM, the delivery would be on
> time. But if I use the IF function of O5>N5 it give me a TRUE answer when
> in
> fact it is FALSE. What would be the correct formula?

 | 
Pages: 1
Prev: Splitting Text from single cell in column across multiple Columns
Next: Multiple IF function