Excel Analog Clock
An experiment in time measurement

Just a little experiment I wrote in Microsoft Excel (2000). It's a working analog clock that keeps time by drawing the clock face into the background of the cells in a spreadsheet. Download here (21kB) ( UPDATED 08/16/2004 ).

There's a couple options that can easily be adjusted in the Globals module under the Visual Basic Editor within Excel. These include:

  • coordinates of the centerpoint of the clock
  • the length of each of the hands
  • the height and width of the clock border (really, this is the length of the )
  • a 'size multiplier' that adjusts all the size parameters at once (everything but the centerpoint and colors)
  • all the color indices used (see the help files for Excel for an explaination of color index values).