formula for evaluating if certain cell's date/time is greater than a specific date/time

[dcwan]

Hello

I don't see anything wrong with the formula, but maybe you all can spot something that I can't see. I suspect the DATEVALUE() & TIMEVALUE issue, but I have tested it and it converts fine, but the logic doesn't seem to be working.

=IF(A1>=DATEVALUE("5/29/2015") & TIMEVALUE("10:15"), 1, 0)

but I'm getting always getting false.

Sample timestamps that I have tested are "5/29/2019 10:15", "3/31/2019 0:00", "6/1/2019 13:00"

[dcwan]

Never mind, I found my mistake...2015 versus 2019

Of course that will never work...dope

[dcwan]

Tried it out, and it still didn't work. Looking carefully at the DATETIME, TIMEVALUE concatenation, it adds an extra 0, so my value goes up by a factor of 10. This is clearly different from just formatting and turning "5/29/2019 10:15" into a number. What is going on?

[63falcondude]

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

[dcwan]

Here is the data set.

[63falcondude]

Try this in B2:

=A2>DATE(2019,5,29)+TIME(10,15,0)

[dcwan]

this works.

Thanks

[63falcondude]

You’re welcome. Happy to help.

Thanks for the rep!