October 10, 2008, Newsletter Issue #277: Convert hours into hours, minutes and seconds in Excel

Tip of the Week

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.

About LifeTips

Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.

Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!


Guru Spotlight
Jerry Mayo