# Excel: How to Convert Time Duration to Minutes

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.