There are limits that apply to times that use this format. If you type a time value into a cell or use a formula to return a time that exceeds the limits, you may notice either of the following behaviors:
- If you enter a time that exceeds the limits, the time may appear as a text string.
For example, if you type the following time20000:00:00the time appears in the cell as a text string aligned to the left.
- If you use a formula to return a time that exceeds the limits, the formula returns a series of pound or number signs (####).
The maximum time value that you can calculate using a formula is 71003183:59:59. This value equates to 12/31/9999 23:59:59, which is the maximum time that you can use in Excel 2000.
For more information about how to use times, click the following article number to view the article in the Microsoft Knowledge Base:
ID d'article : 214386 - Dernière mise à jour : 29 avr. 2008 - Révision : 1