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

  • Thread starter Thread starter adamevans81
  • Start date Start date
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
 
=A2>--"08:00:00"

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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
 
Back
Top