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:

For example:

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

Excel: How to Convert Time Duration to Minutes

Excel: Calculate Difference Between Two Times in Minutes

Excel: Calculate Difference Between Two Times in Hours