How do you convert a decimal to time in Excel?

Answer

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.

Top Related Searches
About -  Privacy -  Careers -  Ask Blog -  Mobile -  Help -  Feedback  -  Sitemap  © 2014 Ask.com