Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 97 and other Software topics.
To convert a number of hours into a more common hours, minutes and seconds format in Excel, follow these two simple steps:
1) Divide the figure by 24, so if the figure is in cell A1, put a formula in any other cell which says =A1/24
2) Then choose the required time format from Format, Cells, Number.
|Sheri Ann Richerson|