Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Converting Hours in Decimal Form to HH:MM:SS Format
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