(Online Percentage Clock for Time and Date Created by David Alderoty) This is the Online Percentage Clock for Time and Date, which was created with Microsoft Excel. Below the code used to create this device is displayed, which is comprised of spreadsheet formulas and custom formatting code. However, the device below was created by electronically converting the Excel version to JavaScript, which functions online in a conventional web browser. If you want to see the JavaScript code, left click on the link below.

If you want to see the JavaScript code, left click here.

If you want to see the If you want to see the Online Percentage Clock for Time and Date, without the code left click on these words, or go to www.TechForText.com/Time-and-Date

The time and date you see below, is based on the time that you access this website. If you want the exact time, and this webpage was opened for a while, left click on the update button below.

The code for the above is excels function=TODAY() coupled with the following custom formatting code: "Today is" dddd, mmmm d, yyyy

The code for the above is excels function =NOW() coupled with the following custom formatting code: "The time is" h:mm AM/PM

The code for the above is =ROUND((B10-B8)*100, 2) coupled with the following custom formatting code: 0.00"% of the day is gone"

The code for the above is =ROUND((1-(B10-B8))*100, 2) coupled with the following custom formatting code: 0.00"% of the day remains"

The code for the above is =B10-B8 coupled with the following custom formatting code: h" hours and" m" minutes of the day is gone"

The code for the above is =1-C16+1/(24*60) coupled with the following custom formatting code: h" hours and" m" minutes of the day remains"

Created by David Alderoty © 2012

To contact the author use this e-mail address David@TechForText.com

Or left click on these words for a website communication form

If you want this clock in the Microsoft Excel format, you can download it by left clicking on the link below. The download is provided free of charge, in a zipped folder, with two files one is for Microsoft Excel 2003 and the other for Excel 2010, both of which require Microsoft Windows. Also included in the folder, are a couple of JavaScript versions of the clock, which will run with most operating systems.

Left click on these words to download the above.