Tag: HOUR

Short Tips#0019: Know the functions HOUR, MINUTE and SECOND

Tagged with: , ,

Lesson#81: Making an automatic analog clock in excel with pie chart

Previously I had discussed about 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 pie chart Now I will add some simple VBA to make

Tagged with: , , , , ,

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

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

Tagged with: , , , ,

Lesson#61: Making a semi analog clock with pie chart

OK friends! How is everyone. Now in this post we will learn an unusual trick to make a semi analog clock with Pie Chart. Let’s see. First I have made 3X3 table for hour, minute, second of current time.  

Tagged with: , , , , , ,

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

Lesson#16 will introduce you with some more new function TODAY, NOW, HOUR, MINUTE, SECOND, YEARFRAC. Function TODAY returns current date formatted as date.   Function NOW returns current date and time formatted as date and time. HOUR(serial_number) returns the hour as a number from 0 (12:00

Tagged with: , , , , ,
Top