Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|