Microsoft Office Tutorials and References
In Depth Information
The serial number equivalent of one minute is approximately 0.00069444. The following
formula calculates this number by multiplying 24 hours by 60 minutes, and dividing the result
into 1. The denominator consists of the number of minutes in a day (1,440):
Similarly, the serial number equivalent of one second is approximately 0.00001157, obtained
by the following formula:
In this case, the denominator represents the number of seconds in a day (86,400).
In Excel, the smallest unit of time is one 1,000th of a second. The time serial number
shown here represents 23:59:59.999 (one 1,000th of a second before midnight):
Table 16.2 shows various times of day along with each associated time serial number.
TABLE 16.2 Times of Day and Their Corresponding Serial Numbers
Time of Day
Time Serial Number
12:00:00 AM (midnight)
12:00:00 PM (noon)
As with entering dates, you normally don’t have to worry about the actual time serial
numbers. Just enter the time into a cell using a recognized format. Table 16.3 shows some
examples of time formats that Excel recognizes.