Microsoft KB Archive/45069

Excel Serial Number/Time Unit Equivalents PSS ID Number: Q45069 Article last modified on 05-04-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00 | 2.20 2.21 3.00

WINDOWS | OS/2

Summary:

Microsoft Excel stores dates and times as serial numbers. The following are approximate equivalents for serial numbers in Microsoft Excel:

Serial Number Equivalent ————- ———-

365 Year 31 Month 1 Day 0.75 3/4 Day, 6 PM 0.50 1/2 Day, 12 Noon 0.25 1/4 Day, 6 AM 0.04 Hour 0.0007 Minute 0.00001 Second

More Information:

The exact serial number figure for a time unit can be seen by entering the time into a cell and choosing Show Info from the Window menu to see the value. To do this, perform the following steps:


 * 1) Enter the time in a cell. For example, to get the exact value of 15 minutes, enter 0:15 in cell A1.
 * 2) From the Window menu, choose Show Info.
 * 3) From the Info menu, choose Value.
 * 4) Activate the worksheet where the time has been entered.
 * 5) Select the cell containing the time.

At this point, you may need to choose Arrange All from the Window menu to view the Info window. The number to the right of the word value is the serial number equivalent to 15 minutes.

Reference(s):

“Microsoft Excel User’s Guide,” version 3.0, pages 94-95

“Microsoft Excel Reference,” version 2.x, pages 187-194, 632, 648-654

Additional reference words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 3.00

Copyright Microsoft Corporation 1993.