If you find any of this useful, please consider donating via PayPal to help keep this site going.

Email news@statisticool.com to sign up to receive news and updates

Random Clocks


With the recent Coronavirus Disease 2019 (COVID-19), many children are at home because schools are closed. Education and fun, however, should not stop. Here is a spreadsheet I created that creates random analog clocks for students to practice their time, or estimating the time.

When you open up the spreadsheet, it creates three clocks with randomly generated times. It does this by creating a random angle, and converting this to rectangular coordinates. I keep the magnitude (i.e. length) of the hour hand half as big as the length of the minute hand. I also make the hour hand thicker than the minute hand. Note that the positions of the clock hands are not entirely accurate in relation to the numbers on the clock face because I am just creating random angles to draw the hands while the numbers on the clock are just drawn on, but the student should still be able to estimate the time well from this worksheet.

I set the Print Area, that is, the area that will be printed out when you click Print, to be the area with the words in the outlined box. This way, you can just open up the spreadsheet and print. You can also press F9 to create new random numbers.

Click here to download the spreadsheet.

You are free to edit this spreadsheet as needed. If you find this spreadsheet useful, please credit Statisticool.com.

Thanks for reading.

Please anonymously VOTE on the content you have just read:


If you enjoyed any of my content, please consider supporting it in a variety of ways:

AFFILIATE LINK DISCLOSURE: Some links included on this page may be affiliate links. If you purchase a product or service with the affiliate link provided I may receive a small commission (at no additional charge to you). Thank you for the support!