Article ID: 72578 - View products that this article applies to.
This article was previously published under Q72578
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 LaterTo convert the number, follow these steps:
Microsoft Excel Versions 4.0 and EarlierTo convert the number, follow these steps:
"User's Guide," version 5.0, pages 111, 209-218
"Function Reference," version 4.0, pages 433-434
"Function Reference," version 3.0, pages 236-237
Article ID: 72578 - Last Review: November 16, 2006 - Revision: 1.4
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.