World Clock in Excel

[LondonHoney]

Hello everyone

I would like to display pictures of real-time digital clocks in an Excel
spreadsheet to show different countries with their time zones. I've seen
various websites with the types of clocks I want to show, but I have no idea
how to import them into Excel.

I see HTML codes or Embed codes, but how do I use them so the actual clocks
show? I'm not sure it's even possible, but I thought I'd try the experts.

I am aware of using =NOW codes but I want to make it more fancy.

Any ideas please?

Thank you!

 

[JLatham]

Maybe provide a link or two to a couple of sites that have the type of
displayed clock you're trying to come up with? That'll give others an idea
of what you're goal is.

And, no, I don't think too many are going to jump in if you're looking for
something like this:
http://www.yugop.com/ver3/stuff/03/fla.html <G>

 

[dlw]

find a nice jpg of a world map, do a Format/Sheet/Background, then position
your =now()'s where you want, remove gridlines, do a macro that
re-calculates now and then, there ya go.

If you are going to muck with HTML, why use excel, just make it a web page...

 

[LondonHoney]

Thank you JLatham and dlw.

Since I posted my question I have found a clock on the following website
that that I would like to use:

http://www.clocklink.com/gallery.php?category=DIGITAL

# 5001.

Once I've got the City I want, how do I put that into an Excel worksheet so
it shows as a digital clock?

 

[JLatham]

Try the workbook linked to below. I hope it's close to what you're looking
for.

All of the code (macros) in it are associated with the WorldClock sheet, so
you can simply copy both sheets into any workbook to get the functionality.

While you have the WorldClock sheet selected, the system may be somewhat
unresponsive as the code runs in a pretty 'tight' loop. But when you select
another sheet, it'll go back to normal as the clock won't be continously
updated while you're not using the sheet.
http://www.jlathamsite.com/uploads/WorldClock.xls
It's in Excel 5-2003 compatible format, so should run for you easily.
My email addy is on the setup sheet if you want to know how it actually works.

 

[norders]

Try the workbook linked to below.  I hope it's close to what you're looking
for.

All of the code (macros) in it are associated with the WorldClock sheet, so
you can simply copy both sheets into any workbook to get the functionality..

While you have the WorldClock sheet selected, the system may be somewhat
unresponsive as the code runs in a pretty 'tight' loop.  But when you select
another sheet, it'll go back to normal as the clock won't be continously
updated while you're not using the sheet.http://www.jlathamsite.com/uploads/WorldClock.xls
It's in Excel 5-2003 compatible format, so should run for you easily.
My email addy is on the setup sheet if you want to know how it actually works.








- Show quoted text -

Here's a link to another World Clock Excel app that implements a
moving band of night and day across a map of the world with major city
times across the bottom. While it might not be exactly what you're
looking for it might give you a few ideas and you can take it apart
and look at the code.

http://www.nordberg.co.uk/ExcitingExcel/worldclock.htm

Enjoy!

 

[David Biddulph]

That application seems to be confused, as it thinks that London is on GMT+1
and Paris on GMT+2.
--
David Biddulph

Here's a link to another World Clock Excel app that implements a
moving band of night and day across a map of the world with major city
times across the bottom. While it might not be exactly what you're
looking for it might give you a few ideas and you can take it apart
and look at the code.

http://www.nordberg.co.uk/ExcitingExcel/worldclock.htm

Enjoy!

....

 

[norders]

That application seems to be confused, as it thinks that London is on GMT+1
and Paris on GMT+2.
--
David Biddulph




...

You spotted the deliberate error! I've uploaded a later version which
has the correct DST checking.