You can use the following formula to convert a time duration to minutes in Excel:
This particular formula converts the time duration in cell B2 to minutes.
For example, if the time is 10:14:22 then the formula will convert this to 614.37 so that the time is represented as 614.37 minutes.
The following example shows how to use this formula in practice.
Example: Convert Time to Minutes in Excel
Suppose we have the following dataset in Excel that shows the number of hours, minutes, and seconds it took various athletes to finish a competition:
We can ensure that the values in the Duration column are formatted as durations by highlighting the range B2:B11, then clicking the Number Format dropdown, then clicking More Number Formats:
We can then click the Category on the left called Custom, then choose h:mm:ss, then click OK:
Next, we can use the following formula to convert the durations into minutes:
We will type this formula into cell C2 and then click and drag the formula down to each remaining cell in column C:
The new Minutes column displays the time in the Duration column as minutes.
- A duration of 10 hours, 14 minutes, and 22 seconds is converted to 614.3667 minutes.
- A duration of 26 hours, 14 minutes, and 22 seconds is converted to 1,547.367 minutes.
- A duration of 13 hours, 30 minutes, and 0 seconds is converted to 810 minutes.
And so on.
Note: In this formula we multiply the time durations by 24 hours in a day and then by 60 minutes in an hour allows us to convert time durations to minutes.
The following tutorials explain how to perform other common operations in Excel: