Previously I had discussed how to make an analog clock with piechart in excel. I am sharing the post link below. Lesson#61: Making a semi-analog clock with a pie chart Now I will add some simple VBA to make the …

Lesson#81: Making an automatic analog clock in excel with a pie chart Read more »

We will learn how to make an automatically refreshing bar clock in excel. 1. First I made three merged cells by putting these formulas =HOUR(NOW()) =MINUTE(NOW()) =SECOND(NOW())   2. Select those cells one by one and click on Conditional Formatting>Data …

Lesson#80: Make an automatically refreshing bar clock in Excel Read more »

Lesson#16 will introduce you to some more new function TODAY, NOW, HOUR, MINUTE, SECOND, YEARFRAC. Function TODAY returns the current date formatted as a date. Function NOW returns the current date and time formatted as date and time. HOUR(serial_number) returns the hour as a …

Lesson#16: Know about function TODAY, NOW, HOUR, MINUTE, SECOND, YEARFRAC Read more »