The information in this article applies to:
SUMMARYMicrosoft Excel limits the maximum time value that you can enter into a cell or return by using a formula. This article explains the limits in different versions of Microsoft Excel. MORE INFORMATION
In Microsoft Excel, versions 5.0 and later, you can enter times that exceed
24 hours by using a number format that includes "[h]" (without the
quotation marks). The square brackets around the "h" instruct Microsoft
Excel to calculate times beyond 24-hour intervals, which allows you to
enter times that exceed 24 hours. If you enter a time that exceeds 24
hours, Microsoft Excel automatically applies a number format that includes
the "[h]" code.
Microsoft Excel for the Macintosh, versions 5.0, 5.0aThe maximum time that you can enter into a cell is 1569143:59:59. This time is equivalent to 12/31/2078 23:59:59, which is the maximum time you can use in these versions of Microsoft Excel.The maximum time that you can calculate using a formula is also 1569143:59:59. Microsoft Excel 98 Macintosh EditionThe maximum time that you can enter into a cell is 9999:59:59. If you enter a time that is greater than or equal to 10,000 hours (10000:00:00), the time appears as a text string.The maximum time that you can calculate using a formula is 71003183:59:59. This time is equivalent to 12/31/9999 23:59:59, which is the maximum time you can use in Microsoft Excel 98 Macintosh Edition. REFERENCESFor more information about using times in Microsoft Excel, please see the following articles in the Microsoft Knowledge Base: Q95948 XL: Using Dates and Times (XE0127) Complete Text Q99349 XL: Working with Time Periods That Exceed 24 Hours Q168435 XL: Maximum Times in Microsoft Excel Additional query words: XL5 XL98 5.00a [h]:mm [h]:mm:ss pound key
Keywords : xlformat xlmac |
Last Reviewed: September 9, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |