Date/Time Comparison

[High_Road]

I have a cell containing a Date and Time.

1/16/2013 7:00am in A1 for example.

I need a formula to check if this is 3:00am or not.

I've tried all sorts of things and they don't seem to work.

=IF(MOD(A1,1)-.125=0,"YES","NO") ??

[Kevin UK]

Hi High_Road

Try

Please Login or Register  to view this content.

[High_Road]

So weird.

So if I run =A1-INT(A1) on a Date/Time at 3:00am it returns .125 which is correct.
But, as soon as I put it in the IF statement:
=IF(A1-INT(A1)=(3/24),"YES","NO") it returns a NO??

[High_Road]

Ok...


SO:

=IF(AND(A1-INT(A1)>.124,A1-INT(A1)<.126),"YES",NO")

This works, so A1-INT(A1) is >.124 and <.126 but not =.125?

The dates and times stem from a TODAY() function. Does that maybe introduce some sort of discrepancy? I'll use the AND statement for now.

[Kevin UK]

Hi

That's right, If in A1:
16/01/2013 03:00 = Yes
16/01/2013 13:19 = No