# 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.

## 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. ### 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.  ### 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")` • Press ENTER. Excel will show the output. • Use Fill Handle to AutoFill up to D10. ## 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 Bin Rashid

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  