This is what I was looking for, how would I set up a macro to refresh?
--
MikeG


"Gary''s Student" wrote:

There are two basic approaches:

1. local reference
2. GMT reference

1. if your computer is, say, in Princeton NJ then
=NOW() will give you the local time
=NOW()-3 will give you time time in San Francisco

You can refresh the times with F9 at your desired frequency

REMEMBER: You wil have to make adjustments to some of the formulas to
accomodate local DST conventions


2. enter GMT (Zulu) (UTC) in a cell and create offsets from this time. This
has the advantage that the spreadsheet will work where every you are. You
will still have to make periodic adjustments to the formulas to accomodate
local DST.

Once again you can refresh the times with F9 or with a macro.
--
Gary''s Student - gsnu200764


"MikeG" wrote:

I am looking for a way to use cells in a spreadsheet as live clocks. I want
to be able to show the live times in multiple cities using the cells in a
spreatsheet. Anyone know if this is possible?
--
MikeG