=IF(HOUR(NOW()8,1,0)
or
=--(HOUR(NOW())8)
But be aware that the worksheet will need to recalculate for this formula to
change values as the time progresses
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Eric" wrote in message
...
Does anyone have any suggestions on how to set the formula?
If current time for today only is greater than 8 pm, then return 1 in cell
A1, else return 0.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric