If Statement > Time

[krugs19]

Hello,

I am attempting to give a value for times greater than 19:00 on my list (0 or 1). I have changed the format of the actual start times to everything I know to do (hh:mm, text, text to columns shows am/pm etc) and I cannot seem to get =if(A2>"19:00",1,0) to work. I tried 07:00 pm... The default for A2 is 2/27/2013 10:00:00 AM etc.

Actual Start After 19:00
10:00
16:29
10:00
10:00
19:51
19:51
19:51
16:29
16:29

[Jonmo1]

Your posted formula is reading "19:00" as a text string, not a time value.
Try
=if(A2>"19:00"+0,1,0)
The +0 converts the Text value to a real Time value.

However, since you usaid A2 is 2/27/2013 10:00:00 etc..
That means A2 is not only a time value, it's a date and a time together.

So you have to strip only the time from that cell.
This will do that
=MOD(A2,1)

Put it together, it would be

=if(MOD(A2,1)>"19:00"+0,1,0)

[krugs19]

That works great thank you.

[Jonmo1]

You're welcome.