Building a World Clock is not an easy task, especially due to Daylight Saving Time. So the easiest way to get the time for different cities is… to rely on an online service.
ClockLink has an impressive gallery of Flash based analog and digital clocks. The Flash widget is highly customizable, as you can enter the model, color and location as parameters. So this is a perfect fit for a calculated column. An example:
By clicking on the above link, you’ll get the clock model 0012, in light blue color (ltblue), for San Diego.
Let’s go ahead and build our SharePoint list. I chose a custom list with the following columns:
– City: text column (San Diego)
– Country_City: text column (USA_SanDiego)
– Model: choice column (0012, etc.)
– Color: choice column (dkblue, ltblue, blue, red, silver, green, magenta, etc.
– Clock: calculated column with the following formula:
="<DIV><embed src='http://www.clocklink.com/clocks/"&Model&"-"&Color&".swf?TimeZone="&Country_City&"' width='150' height='150' wmode='transparent' type='application/x-shockwave-flash'></DIV>"
The last step is to apply our “HTML calculated column” method to convert the HTML strings into actual HTML.
Check out the result on the home page of my demo site: