Follow the below steps carefully to do so. We will insert a VBA code that will generate the current time in our dataset and the text function will convert the time into text formats and display it in our clock. In our first method, we will thoroughly use the TEXT function and Excel VBA to build a digital clock with an automatic refresh. Build Digital Clock Through Excel VBA and TEXT Function To demonstrate, we take a dataset representing the function and cases needed to create a digital clock.ġ. We will align the clock time with our PC time and thus it will match the hours, minutes & seconds every time we open the workbook.

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.2 Suitable ways to Create Digital Clock in ExcelĬreating a digital clock in with automatic refresh can be easy if we carefully follow some easy procedures.

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.

Digital clock in excel file download