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

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

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

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

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

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