Microsoft KB Archive/72578

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

Article ID: 72578

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q72578




 * Microsoft Excel for Windows 2.0|2.0
 * Microsoft Excel for Windows 2.01|2.01
 * Microsoft Excel for Windows 2.1|2.1
 * Microsoft Excel for Windows 2.10c|2.10c
 * Microsoft Excel for Windows 2.10d|2.10d
 * Microsoft Excel for Windows 3.0|3.0
 * Microsoft Excel for Windows 3.0a|3.0a
 * Microsoft Excel for Windows 4.0|4.0
 * Microsoft Excel for Windows 4.0a|4.0a
 * Microsoft Excel for Windows 4.0c|4.0c
 * Microsoft Excel for Windows 5.0c|5.0c
 * Microsoft Excel for Windows 95 7.0a|7.0a
 * Microsoft Excel for the Macintosh 3.0|3.0
 * Microsoft Excel for the Macintosh 4.0|4.0
 * Microsoft Excel for the Macintosh 5.0|5.0
 * Microsoft Excel for the Macintosh 5.0a|5.0a





SUMMARY
If you want to convert hours displayed in decimal form so that they can be displayed in a time format such as hh:mm:ss (for example, to convert 2.1 to 2:06:00), use the following the appropriate procedure for your version Microsoft Excel.



Microsoft Excel Versions 5.0 and Later
To convert the number, follow these steps:


 * 1) Use the following formula to convert the number (n) to a serial number

=n/24

where n is any decimal number representing hours.
 * 1) On the Format menu, click Cells, and then click the Number tab.
 * 2) Under Category, select Time, and under Format Codes, select the number format you want.

Microsoft Excel Versions 4.0 and Earlier
To convert the number, follow these steps:


 * 1) Use the following formula to convert the number (n) to a serial number

=n/24

where n is any decimal number representing hours.
 * 1) On the Format menu, click Number, and select the desired number format (for example, select hh:mm:ss).

NOTE: You can also use these procedures to convert from 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.

