In Microsoft Excel, when you enter a time into a cell, the cell may change
to the General number format, and display a decimal number.
↑ Back to the top
This behavior occurs when you enter an improper time value, where the
minutes are greater than or equal to 60. For example if you type 5:62, the cell displays "0.251389"
↑ Back to the top
To work around this problem, change the cell to the Time number format:
- Click to select the cell.
- On the Format menu, click Cells.
- On the Number tab, click Time in the Category list, and then click the
time format you want in the Type list. Click OK.
↑ Back to the top
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
↑ Back to the top
For more information about number formatting, click Microsoft Excel Help on the
Help menu, type format numbers in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned.
↑ Back to the top