Converting a Decimal Number to hh:mm:ss Format in Excel
This article was previously published under Q75618
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
The following formula converts decimal minutes to the hh:mm:ss formatin Microsoft Excel
where "Minutes" is a decimal number between 0.0 and 1440.0. The portion ofthe number to the left of the decimal refers to the number of minutes.The decimal portion of the number refers to seconds. 1439.0 minutes isequal to 23 hours and 59 minutes and converts to "23:59:00". There are1440.0 minutes in 24 hours. Using the formula shown above will return aserial number. To display the serial number in the appropriate format,choose Number from the Format menu (or, on the Format menu, click Cells,and then select the Number tab) and select hh:mm:ss.
To convert hours and minutes from a decimal number to the hh:mm:ss formatuse the following formula:
ExampleUse this formula to convert 4.5 minutes to 0:04:30:
Use this formula to convert 4.5 hours to 04:30:00:
"Microsoft Excel Function Reference," version 3.0, pages 200, 236, 239
Article ID: 75618 - Last Review: 11/16/2006 04:36:32 - Revision: 1.4
Microsoft Excel 97 Standard Edition, Microsoft Excel 95 Standard Edition, Microsoft Excel 5.0 Standard Edition, Microsoft Excel 98 for Macintosh