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

A

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
 
B

Bob Phillips

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

--

HTH

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

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
 
Top