Convert Number of Minutes to Hours and Minutes in Excel 2010

Excel stores Date and Time in number form. To convert hours from one standard time format to other we can use the Convert Function.

In column A, we have Minutes &we need to convert the number of Minutes to Hours in column B.

 

Convert: Converts a number from one measurement system to another.

Syntax =CONVERT(number,from_unit,to_unit)

 

Let us take an example:

    • In cell B2 type =Convert select cell A2as first argument which contains Minutes
    • The second argument in the Convert Function is from_unit which is “mn” for Minutes.

img1

 

  • In the third argument enter or select to_unit as “hr” for Hour

img2

 

Let us take another example of Converting Days into Minutes

In cell A2 & B2 we have Date & Time.

Cell A2 has 7/1/2014 5:15:00 PM
Cell B2 has 7/3/2014 5:15:00 PM

To calculate Number of Days in cell C2 we will take the difference between start time & end time.

img3

 

In cell D2 we have used the Convert Function. This function will convert Number of Days to Minutes.

Steps:

    • In cell D2 type =Convert select C2 as the first argument which contains Number of Days
    • The second argument in the Convert function is from_unit which will be “day”

img4

 

    • In the third argument select to_unit as “mn”for Minute

img5

 

  • This is how our output appears -

img6

 

We can calculate the Hours by dividing the minutes by the multiplication of 24 hours *60 minutes. Refer the below screenshot:

In column A, we have the minutes & we are calculating the hours in column B -

img7

 

After applying custom Formatting in column B as h:mm, see output in below screenshot:

img8

Users are saying about us...

  1. Great job on explaining. Solved my problem.

    What I cant figure out is how do I add a column with “hours” and a column with “minutes” to sum both into “hours & minutes”?

    • 175 clock rings (i.e. Begin tour – 0700: out for lunch- 1130: inform lunch – 1230: end of day 2:30
      How do I convert these times to hours worked?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube