Microsoft KB Archive/214125

= XL2000: Converting Hours in Decimal Form to HH:MM:SS Format =

Article ID: 214125

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214125





SUMMARY
This article shows you how to convert hours displayed in decimal form to a time format such as hh:mm:ss (for example, converting 2.1 to 2:06:00).



MORE INFORMATION
To convert a number, follow these steps:  Use the following formula to convert the number to a serial number

= /24

where  is any decimal number representing hours. On the Format menu, click Cells, and then click the Number tab. Under Category, select Time; under Type, select the number format that you want.

NOTE: You can also use this procedure to convert time values to decimal values. To do this, start from a time value, convert it to a decimal format, and then multiply by 24 to get the decimal representing the time value.

Additional query words: XL2000

Keywords: kbhowto kbinfo KB214125

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.