TIMER

[Jase]

I am looking for a code that will constantly check the time from a website or
the computers time ( preferably a website for accuracy) and every half hour,
on the 00 & 30, it grabs the time and writes it to a couple cells. So cells
A1 will have hour and B1 will have minute. Is their a way this can be done.
I don't want to use the =time code, it slows my worksheets down.

Any suggestions?

thanks,

Jase

 

[Harald Staff]

Hi Jase

See Chip's page
http://www.cpearson.com/excel/OnTime.aspx
Note that all code will slow your application down to some degree, and at
times clear the Undo memory.

HTH. Best wishes Harald