Date/Time Comparison

**High_Road** · 01-16-2013, 08:34 AM

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** · 01-16-2013, 08:42 AM

Hi High_Road

Try

Formula:

=IF(A1-INT(A1)=3/24,"YES","NO")

**High_Road** · 01-16-2013, 09:21 AM

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.

**High_Road** · 01-16-2013, 09:11 AM

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??