Hi All,

I'm trying to complete the calculation like above however this doesn't
work for me.

It only works when I put a cell in the time part i.e IF(A2>B2,TRUE,
FALSE)and in B2 i have 08:00:00 AM

Can anyone spot what I'm doing wrong?

Adam

=A2>--"08:00:00"

--

HTH

RP
(remove nothere from the email address if mailing direct)


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
>
> I'm trying to complete the calculation like above however this doesn't
> work for me.
>
> It only works when I put a cell in the time part i.e IF(A2>B2,TRUE,
> FALSE)and in B2 i have 08:00:00 AM
>
> Can anyone spot what I'm doing wrong?
>
> Adam
>

Hi Adam

Not really, but datetime data is vulnerable stuff. Important information can
be formatted away, and invalid data may look fine. This works for me, for
8:00 spesifically:
=MOD(A2,1)>(1/3)
and with B2 instead
=MOD(A2;1)>B2

The MOD part takes any date information away. As all geeks know; Dates may
be a big problem.

HTH. Best wishes Harald


<(E-Mail Removed)> skrev i melding
news:(E-Mail Removed)...
> Hi All,
>
> I'm trying to complete the calculation like above however this doesn't
> work for me.
>
> It only works when I put a cell in the time part i.e IF(A2>B2,TRUE,
> FALSE)and in B2 i have 08:00:00 AM
>
> Can anyone spot what I'm doing wrong?
>
> Adam
>

Hey Adam

Try this =IF(A2>TIMEVALUE("08:00"),TRUE,FALSE)

Jerry Oyler

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
>
> I'm trying to complete the calculation like above however this doesn't
> work for me.
>
> It only works when I put a cell in the time part i.e IF(A2>B2,TRUE,
> FALSE)and in B2 i have 08:00:00 AM
>
> Can anyone spot what I'm doing wrong?
>
> Adam
>