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

Consider the following dataset, with some employees and their working times in hours in column C. We will convert these numbers to minutes.

### Method 1 – Convert a Number to Minutes Manually in Excel

Steps:

• Go to D5 and use the following formula:
`=C5*60`

• Hit Enter.

• Use the Fill Handle to AutoFill to D10.

### Method 2 – Use the CONVERT Function to Convert Numbers to Minutes in Excel

Steps:

• Go to D5 and use the following formula:
`=CONVERT(C5,"hr","mn")`

• Press Enter.

• Use the Fill Handle to AutoFill to D10.

## Things to Remember

• You can also convert time between other time units, such as seconds.
• While writing the CONVERT function, Excel will give you a list of choices for units you can convert between.

You can either choose from these options or write manually.

## Related Articles

Get FREE Advanced Excel Exercises with Solutions!
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

Advanced Excel Exercises with Solutions PDF