I wrote a post about making a clock face in Visio fifteen years ago, but a reader recently asked about displaying multiple time zones. Well, I have previously written about time zones in Visio, so I accepted the challenge to improve upon my earlier work.
In this update, an alternate time zone can be selected from a drop-down list. The Time Zone Time will be calculated, and, if a label is added, then the label and alternate time zone time is displayed rather than the PC time.
The Visio file can be downloaded from here, or viewed below:
The Clock master can be dragged from the local Document Stencil in this file, and dropped onto any other Visio page.
BTW, I have noticed that the NOW() function works every minute, if the Synchronize option is TRUE, when the document is open in Visio desktop, and it uses the Windows datetime values. My laptop is set to UK time, but when I save the document to OneDrive, and then view the file online, I see that the time display is that of the MIcrosoft server. And, of course, the NOW() function does not work online.
Update any Visio ShapeSheet cell with External Data
When Microsoft introduced a new way of linking external data to Visio shapes in 2007, I initially bemoaned the inability to update anything but Shape Data row values, unlike the old database add-on that I had been using for 10 years. The new method, though, has many advantages over the old way, not least that…
Referencing Container Data in Visio
Microsoft Visio has a useful Structured Diagramming concept that consists of Containers, Callouts and Connectors. The first of these features make it possible for shapes to know what they are contained within, as a better option to grouping shapes together. Grouping can hide or break the grouped shapes smartness, so Visio provides two ways of…
Understanding Morse Clicks with Visio
A few years ago, I wrote an article about messaging and encryption inspired by a visit to the National Museum of Computing in the UK. I developed a Morse Click shape to demonstrate how Visio can be used to represent and learn Morse Code. However, I never published the shapes here, and my good friend…
Correcting the Text Control Handle on Visio Network Shapes
There are literally thousands of master shapes in the stencils supplied with Microsoft Visio, so I guess that mistakes can creep in. One error that I have noticed is the inability of the default text control handle of many of the network shapes to actually move the text block horizontally. (more…)
Using a formula for Shape Data labels prevents multiple updates
I have only been developing Visio solutions for 25 years, but I got a surprise this week when I was trying to understand why I couldn’t update the value of a Shape Data row of multiple selected shapes. It is something that I often do, so it took me a while to understand why I…
Automatically displaying Visio shape text in other shapes
There are times, in Visio, when you just need to ensure that the text in a primary shape is synchronised with the text in different secondary shapes … even if they are on different pages of a Visio document. My previous article, Forcing Display Update of Inherited Data Values , describes a method of synchronising…
Leave a Reply