Lesson#61: Making a semi analog clock with pie chart
![Lesson#61: Making a semi analog clock with pie chart](https://excelabcd.co.in/wp-content/uploads/2018/03/excelabcd-lesson-61.png)
![](https://excelabcd.co.in/wp-content/uploads/2018/03/61-1.png)
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 a 3X3 table for the hour, minute, and second of the current time.
![](https://excelabcd.co.in/wp-content/uploads/2018/03/61-2.png)
Here in this Hour cell, I have put this formula =MOD(HOUR(NOW()),12) to show the current hour in 12-hour format as it shows in the analog clock.
![](https://excelabcd.co.in/wp-content/uploads/2018/03/61-3.png)
In the minute cell, I put the formula =MINUTE(NOW()) to show the minute of the current time.
![](https://excelabcd.co.in/wp-content/uploads/2018/03/61-4.png)
In the second cell I put the formula =SECOND(NOW()) to show the second of the current time.
![](https://excelabcd.co.in/wp-content/uploads/2018/03/61-5.png)
Now below them, I have added another row and that is the trick that shows the value 12-hour.
![](https://excelabcd.co.in/wp-content/uploads/2018/03/61-6.png)
and 60-minute
![](https://excelabcd.co.in/wp-content/uploads/2018/03/61-7.png)
and 60-second
This value is required to make the pie chart.
![](https://excelabcd.co.in/wp-content/uploads/2018/03/61-8.png)
Now I am adding a pie chart of hours by selecting the hour value and 12-hour value as shown in the picture.
![](https://excelabcd.co.in/wp-content/uploads/2018/03/61-9.png)
Now I am adding another pie chart of minutes by selecting the minute value and 60-minute value as shown in the picture.
![](https://excelabcd.co.in/wp-content/uploads/2018/03/61-10.png)
Added another pie chart of minutes by selecting the second value and 60-second value as shown in the picture.
![](https://excelabcd.co.in/wp-content/uploads/2018/03/61-11.png)
![](https://excelabcd.co.in/wp-content/uploads/2018/03/61-12.png)
Leave a Reply