XL2000: Converting Hours in Decimal Form to HH:MM:SS Format (214125)


The information in this article applies to:

  • Microsoft Excel 2000
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:
  1. Use the following formula to convert the number to a serial number

    =n/24

    where n is any decimal number representing hours.
  2. On the Format menu, click Cells, and then click the Number tab.
  3. 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.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbhowto kbinfo KB214125
©2003 Microsoft Corporation. All rights reserved.