The Fibonacci Clock is getting quite some attention on the web lately. Check it out here and read about how it works.
Short summary: The clock consists of five squares with different magnitudes: 5 – 3 – 2 – 1 and 1 again.
Add up the magnitudes for the red and the blue squares to arrive at the number of hours.
Add up the magnitudes for the green and the blue squares, multiply the result by 5 to arrive at the number of minutes.
Ignore white squares.
Minutes are rounded to the nearest 5. AM and PM don’t exist.
So, the time 9:25 looks like this:
Red and blue squares are magnitudes 5 + 3 + 1 = 9. That’s the hour.
Green and blue squares are magnitudes 3 + 2 = 5. Multiply by 5 = 25. That’s the minute.
Not everybody may be willing to pay for the hardware version of the clock, but even if you will get one, you will need some practice to get comfortable reading what it says. So here is your free Fibonacci Clock created with Microsoft Excel.
This is really great and a major advancement. Instead of just glancing at the clock and knowing instantly what time it is, you now need to spend upwards of 5 seconds, maybe up to minutes, to work out what the time is by adding up colour-coded squares. Yep. It’s for nerds. Geeks welcome.
All you need is a working version of Excel on your device. It will work on Excel for your computer (PC or Mac), Excel for iOS, or Android, and with Excel on-line, because it only uses conditional formatting and a few formulas. There’s no VBA code involved. Here’s a screenshot of the file on my iPhone:
Many time stamps can be represented with various combinations of the squares. I’ve used formulas and conditional formatting to arrive at a combination that has the correct time and not too many blue squares.
Download the attached file and play with the settings. You can use the system time and edit any cell to refresh the clock, or enter a time manually and practice how to read it.