How to Convert Number to Minutes in Excel (2 Easy Methods)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, we need to convert time from one format to another for our convenience. We can easily do that in Excel. In this article, I will show 2 easy methods to convert number to minutes in Excel.


Download Practice Workbook

Download this workbook and practice while going through the article.


2 Easy Methods to Convert Number to Minutes in Excel

This is the dataset for today’s article. We have some employees and their Working Time in hour. I will convert these numbers to minutes.

convert number to minutes in excel


1. Convert Number to Minutes Manually in Excel

The first method is to convert these numbers manually. As 60 minutes comprise an hour, the easiest way to convert time from hour to minute is to multiply the number of hours with 60.

Steps:

  • Go to D5 and write down the following formula.
=C5*60

  • Now, press ENTER. Excel will return the output.

convert number to minutes in excel

Read More: Convert Number to Hours and Minutes in Excel (2 Easy Methods)


2. Use of CONVERT Function to Convert Number to Minutes in Excel

Now I will discuss another easy method. This time I will use the CONVERT Function.

Steps:

  • Go to D5 and write down the following formula
=CONVERT(C5,"hr","mn")

convert number to minutes in excel

  • Press ENTER. Excel will show the output.

  • Use Fill Handle to AutoFill up to D10.

convert number to minutes in excel

Read More: Convert Number to Time hhmmss in Excel (2 Suitable Ways)


Things to Remember

  • You can also convert time from one format to other using some relations such as
    • 1 day = 24 hr
    • 1 min = 60 sec etc.
  • While writing the CONVERT function, Excel will give you a list of choices like this

You can either choose from these options or write manually.


Conclusion

In this article, I have demonstrated 2 effective methods on how to convert number to minutes in Excel. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below. Please visit ExcelDemy for more useful articles like this.


Related Articles

Akib
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo