If you are someone who does a lot of Excel work, you probably have found yourself in a situation where you had to convert time to minutes or minutes to a time format. For instance, you may have wanted to change 3:45 to 180 minutes or convert 225 minutes to hours and minutes format. In this tutorial, I’ll show you how to convert time to minutes in Excel and vice versa in a few simple steps.
In Excel, time is stored as a decimal making it easy to use a simple math calculation to do the conversions.
How to Convert Time to Minutes in Excel
Let’s assume that your data is in cell A1.
In the cell where you want to see the result, make sure the formatting is not set to Date or Time but is set to General.
In the cell where you want to see the result, enter the formula:=A1*24*60
RELATED READING: How to Calculate Days Between Two Dates
How to Convert Minutes to Time Format in Excel
To convert minutes to time format in Excel, just use the formula: =A2/24/60
In this scenario, you need to make sure that the cell that displays the result is formatted in a Time format. If you don;t set the format, the result will be displayed in a decimal number format. To do this:
1. Right-click the cell C4 (in my example) and choose Format Cells. This will open up the Format Cells dialog box.
2. On the dialog box, in the Number tab, choose Custom.
3. In the list box, select the h:mm format.
If you found this tutorial helpful, be sure to read all our tutorials in the Learn Excel series. If you want to learn Excel from scratch, consider taking up our Udemy course, Excel 2016 for Beginners, which is available at a nominal price of just $10.
Leave a Reply