Convert Number of Minutes to Hours and Minutes in Microsoft Excel

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

CONVERT function converts a number from one measurement system to another.
Syntax:

=CONVERT(number,from_unit,to_unit)

Let’s do this with an example

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

pasted image 0 (32)

The second argument in the Convert Function is from_unit which is “mn” for Minutes.

unnamed (8)

In the third argument enter or select to_unit as “hr” for Hour.
unnamed (9)

Applying the above formula

=CONVERT(A2,”mn”,”hr”)

unnamed (10)

Copy the formula in other cells, select the cells taking the first cell where the formula is already applied, use shortcut key CTRL + D.

Desired output will be like shown below
HHMMSS

Hope you learned how to use conversion using CONVERT function. You can perform these functions Excel 2013 and 2010. Explore more articles on conversion here. Please let us know if you have any unresolved query. We will help you.

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 to Adam Cancel 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