software

I'm trying to write a logic formula where I am comparing a variable time to a
fixed time. If the variable time is greater than the fixed I assign a value
quot;1quot;, if it is less than I assign the value quot;0quot;. The problem I'm facing is
the fixed time is 12:00 am, so the variable is always considered greater.

The formula I'm trying to use is: =IF(A1gt;A2,1,0) where A1 is the
variable time.

How can I correct this so that 11:50 pm is LESS than 12:00am and 1:00am
is GREATER than 12:00am?

--
Thanks!

RKEMPER

And where is the split? 11:49? 12:00PM?
Why not take 12:00PM as fixed time?
You can also include a date; that makes it a lot more logical.
Now you're trying Excel to tell that 1 gt; 2. Some time, someway, Excel will
strike back.

--
Kind regards,

Niek Otten

quot;rkemperquot; gt; wrote in message
...
gt; I'm trying to write a logic formula where I am comparing a variable time
gt; to a
gt; fixed time. If the variable time is greater than the fixed I assign a
gt; value
gt; quot;1quot;, if it is less than I assign the value quot;0quot;. The problem I'm facing
gt; is
gt; the fixed time is 12:00 am, so the variable is always considered greater.
gt;
gt; The formula I'm trying to use is: =IF(A1gt;A2,1,0) where A1 is the
gt; variable time.
gt;
gt; How can I correct this so that 11:50 pm is LESS than 12:00am and 1:00am
gt; is GREATER than 12:00am?
gt;
gt; --
gt; Thanks!
gt;
gt; RKEMPER