IF(A2>"08:00:00 AM",TRUE, FALSE)

[adamevans81]

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

 

[Bob Phillips]

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

--

HTH

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

 

[Harald Staff]

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

 

[Jerry]

Hey Adam

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

Jerry Oyler