A Binary Clock in Excel

A binary clock, or more accurately a binary-coded decimal clock, shows each digit in binary. I first saw one at a friend’s place and it served as an interesting ice breaker.

The below image is from Excel. Specifically, it is an Excel chart, though most would be hard pressed to recognize it as such. It represents the time 14:30:26 (i.e., 26 seconds past 2:30 pm).

image002

For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/0907%20Binary%20Clock.shtml

Tushar Mehta

Posted in Uncategorized

One thought on “A Binary Clock in Excel

  1. Reminds me of my old Tokyo Flash, incorrectly called a binary watch, when it was in fact more of an abacus.


Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.