How to set the formula - 3 Dec?
 

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

How to set the formula - 3 Dec?
 

=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

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

How to set the formula - 3 Dec?
 

An alternative with fewer functions:

= --(MOD(NOW(),1)=20/24)

However, note that both of them will only update when the sheet is
recalculated, not necessarily one second later than 19:59:59.

In article ,
Daniel Haley wrote:

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