AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Digital clock in excel file download10/8/2023 ![]() Let me know if I’m wrong, but meanwhile here’s a conditional formatting digital clock in a live workbook.Īs the notes in the worksheet above say, you can update this clock by clicking in a cell and hitting F9. But as far as I can tell there aren’t any created using conditional formatting. As I imagined, there are quite a few out there: Juan Pablo Gonzalez already had one on DDOE back in 2004, Andy Pope’s is indistinguishable from the real thing, and Tushar Mehta’s is accurate to within one nanosecond every three years. 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.I was staring at a video player the other day and thinking about digital clocks, specifically, of course, digital clocks created in Excel. I’ve used formulas and conditional formatting to arrive at a combination that has the correct time and not too many blue squares.ĭownload the attached file and play with the settings. Many time stamps can be represented with various combinations of the squares. Here’s a screenshot of the file on my iPhone: ![]() 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. ![]() Geeks welcome.Īll you need is a working version of Excel on your device. 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. This is really great and a major advancement. So here is your free Fibonacci Clock created with Microsoft Excel. 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. Green and blue squares are magnitudes 3 + 2 = 5. Red and blue squares are magnitudes 5 + 3 + 1 = 9. Short summary: The clock consists of five squares with different magnitudes: 5 – 3 – 2 – 1 and 1 again.Īdd up the magnitudes for the red and the blue squares to arrive at the number of hours.Īdd up the magnitudes for the green and the blue squares, multiply the result by 5 to arrive at the number of minutes. ![]() Check it out here and read about how it works. The Fibonacci Clock is getting quite some attention on the web lately. ![]()
0 Comments
Read More
Leave a Reply. |