How to do it in excel?

E

Eric

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
 
K

Kevin B

This should do the trick for you:

=IF(AND(HOUR(NOW())=12,MINUTE(NOW())=30),TRUE,FALSE)
 
D

David Biddulph

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?
 
D

David Biddulph

.... and the IF(...,TRUE,FALSE) is presumably unnecessary. The condition
part presumably returns true or false?
 
R

Ron Rosenfeld

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
Click to expand...

=NOW()>TODAY()+TIME(12,30,0)

--ron
 
Top