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

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Convert Number to Minutes in Excel: 2 Easy Methods

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

  • Use Fill Handle to AutoFill up to D10.

Read More: Convert Number to Hours and Minutes in Excel


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: How to Convert Decimal to Time in Excel Using Formula


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.


Download Practice Workbook

Download this workbook and practice while going through the article.


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.


Related Articles


<< Go Back to Convert Number to Time | Time Conversion | Date-Time in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo