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

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).

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.