=IF(MOD(NOW(),1)K17,"then display this","")
HTH
Jason
Atlanta, GA
-----Original Message-----
How do I, set about entering a formula within a
worksheet that determines if
the Time is greater or less that the time in a certian
cell;
eg =if(now()K17,"then display this","") K17 holding
the Value 08:30 AM
formated to time
.
|