You can use the following formula to convert a time duration to minutes in Excel:

**=VALUE(B2*24*60)
**

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:

**=VALUE(B2*24*60)**

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.

For example:

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

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

Excel: Calculate Difference Between Two Times in Hours

Excel: Calculate Difference Between Two Times in Minutes

Excel: How to Calculate Average Time