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") ??
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") ??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks