If statement with time format

[bigmantitus]

I am trying to do a simple IF statement of something in a time format. For example, =IF(A1=TIME(8,30,0),1,2). I have my cell A1 formatted to 24 hour time (i.e. 08:30), but I can never return a true result. Any thoughts?

[Fotis1991]

Your formula works for me..

[Norie]

Is A1 a real time value, without a date part?

[bigmantitus]

Is A1 a real time value, without a date part?

Yeah, that seems to be the issue. It works fine if the value is just a time value, but once it is a time + date, it fails. My cell will unfortunately be both a date and time. Any way to get around it?

[Norie]

You can extract the time part from A1 and use that in the formula.

Please Login or Register  to view this content.

[bigmantitus]

You can extract the time part from A1 and use that in the formula.

Please Login or Register  to view this content.

Thanks for the response but that doesn't seem to work for me. MOD does pull out the time, but using an IF statement with TIME still doesn't return a true result.

[Norie]

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[popipipo]

Please Login or Register  to view this content.

This formula gives a 1 if it is true and a 2 if it is false
If you want 'TRUE' or 'FALSE' as a result use this formula

Please Login or Register  to view this content.

[bigmantitus]

I have attached the simple workbook. What it eventually displays (either a number or true/false) doesn't matter since I can always customize the true and false results of the IF statement. What I cannot get it to do is ever yield a true result using the TIME function (which is the only way I can think of to try this).

[Norie]

It's a rounding/floating point problem.

Try this instead, though I'm sure there's a better way.

Please Login or Register  to view this content.

[bigmantitus]

That worked! Thanks much.