To convert a number of seconds into a more conventional hours, minutes and seconds time format in Excel, follow these two simple steps:
1) Divide the number by (24*60*60), so if the number is in cell A1, put in a calculation which says =A1/(24*60*60).
2) Then choose the required time format from Format, Cells, Number.
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.
Guru Spotlight |
Carma Spence-Pothitt |