Tag: MINUTE

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#78: Change the color of whole sheet in every minute in Excel

Now I will show how to make a spreadsheet which changes its color in every minute automatically. to make this you have to follow some steps. 1. Click the upper left corner of sheet to select all of the spreadsheet.

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