I have found a macro that looks to refresh itself every second. A1 is
=now()

I have the open and close times for a particular market. Lets say it
opens at 7:00 am (location is C19) and closed at 3:30 pm (location is
C20)

When I do the following:
=if(and($A$1C19,$A$1<C20),”Market is open”,”Market is closed”)

It does not work. I even try to break it into 2 parts. And it still
does not seem to work.

Any ideas?


--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=526117