September 26, 2008, Newsletter Issue #275: Converting hours and minutes into minutes in Excel

Tip of the Week

There is a way to convert time expressed in hours and minutes into minutes only, even though Excel doesn´t have a minutes-only format. Enter a measure of time in hours and minutes, such as 2:25, into any cell, such as A1. In another cell, enter the formula =Hour(A1)*60+minute(A1). Excel will then convert the time into minutes.

If the result is still in time format (00:00 or similar), then click the Comma Style button (to the right of the percentage button) on the toolbar or select the General 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
Susan Sayour