For Excel 2010, to convert a decimal into a standard time format, enter the formula "=TEXT([desired cell number]/24, "h:mm")" and replace "[desired cell number]" with the correct cell number. This will change the number into a standard hours, minutes and seconds format.

Reference:

Similar Questions

People Also Asked

Top Related Searches

Wikipedia on Ask.com

This article aims to be an accessible introduction. For the mathematical definition, see Decimal representation.
The decimal numeral system (also called base ten or occasionally denary) has ten...