| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to do it in excel?
If now 12:30 PM, then true else false.
Does anyone have any suggestions on how to do it in excel? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to do it in excel?
This should do the trick for you:
=IF(AND(HOUR(NOW())=12,MINUTE(NOW())=30),TRUE,FALS E) -- Kevin Backmann "Eric" wrote: If now 12:30 PM, then true else false. Does anyone have any suggestions on how to do it in excel? Thanks in advance for any suggestions Eric |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to do it in excel?
=MOD(NOW(),1)TIME(12,30,)
-- David Biddulph "Eric" wrote in message ... If now 12:30 PM, then true else false. Does anyone have any suggestions on how to do it in excel? Thanks in advance for any suggestions Eric |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to do it in excel?
That would look for a time = 12:30 and <12:31. As far as I can see, the OP
had asked for 12:30, and hadn't asked for <12:31? -- David Biddulph "Kevin B" wrote in message ... This should do the trick for you: =IF(AND(HOUR(NOW())=12,MINUTE(NOW())=30),TRUE,FALS E) -- Kevin Backmann "Eric" wrote: If now 12:30 PM, then true else false. Does anyone have any suggestions on how to do it in excel? Thanks in advance for any suggestions Eric |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to do it in excel?
.... and the IF(...,TRUE,FALSE) is presumably unnecessary. The condition
part presumably returns true or false? -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... That would look for a time = 12:30 and <12:31. As far as I can see, the OP had asked for 12:30, and hadn't asked for <12:31? -- David Biddulph "Kevin B" wrote in message ... This should do the trick for you: =IF(AND(HOUR(NOW())=12,MINUTE(NOW())=30),TRUE,FALS E) -- Kevin Backmann "Eric" wrote: If now 12:30 PM, then true else false. Does anyone have any suggestions on how to do it in excel? Thanks in advance for any suggestions Eric |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to do it in excel?
On Fri, 11 Apr 2008 05:20:01 -0700, Eric
wrote: If now 12:30 PM, then true else false. Does anyone have any suggestions on how to do it in excel? Thanks in advance for any suggestions Eric =NOW()TODAY()+TIME(12,30,0) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
