How to set the formula - 3 Dec?
Hi Eric,
Try the following formula.
=IF(HOUR(NOW()-TODAY())=20,1,2)
Note that 20 is 8pm in military time.
Dan
Eric wrote:
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
|