Table of Contents
Converting time formats from hh:mm:ss to minutes in Excel can be done using a simple formula. First, select the cell where you want the minutes to be displayed. Then, enter the formula “=TIMEVALUE(A1)*24*60” where A1 is the cell containing the hh:mm:ss format. This will convert the time into a decimal number representing the total number of minutes. Alternatively, you can also use the built-in function MINUTE(A1) to directly extract the minutes from a time value in the hh:mm:ss format. Both methods will allow you to easily convert time values to minutes in Excel for efficient data analysis and calculations.
Excel: Convert hh:mm:ss to Minutes
You can use the following formula in Excel to convert hh:mm:ss into minutes:
=((HOUR(B2)*60)+MINUTE(B2)+(SECOND(B2)/60))
This particular formula converts the hours, minutes and seconds in cell B2 into minutes.
For example, if cell B2 contains 1:23:30 to represent 1 hour, 23 minutes and 30 seconds, then this formula will return 83.50 to represent 83.50 minutes.
The following example shows how to use this formula in practice.
Example: Convert hh:mm:ss to Minutes in Excel
First, let’s enter the following dataset in Excel that shows the time (in hours, minutes and seconds) that it took for various athletes to finish some task:
Next, we can type the following formula into cell C2 to convert the time in cell B2 into minutes:
=((HOUR(B2)*60)+MINUTE(B2)+(SECOND(B2)/60))
We can then click and drag this formula down to each remaining cell in column C:
By default, Excel will still use a time format.
To instead use a number format, highlight the cells in the range C2:C13, then click the Number Format dropdown menu from the Home tab along the top ribbon, then click Number:
The times in column C will now be shown in a decimal format:
- 55 minutes and 34 seconds is equal to 55.57 minutes.
- 1 hour, 23 minutes and 30 seconds is equal to 83.50 minutes.
- 3 hours, 15 minutes and 1 second is equal to 195.02 minutes.
And so on.
Additional Resources
The following tutorials explain how to perform other common operations in Excel: