Quote Originally Posted by p45cal
=INT(A1)=TODAY() will be true if it's the same date
=MOD(A1,1)>=0.5 Will be TRUE if it's afternoon false if AM (or =HOUR(A1)>=12 )
Indeed they do. Thanks.