How to Convert Hours to Minutes in Excel

This guide explains how to convert Hours to Minutes in Excel, with clear steps, practical tips, and important checks before you begin.

Use math

We have 1 hour = 60 minutes = 3600 seconds, we apply this formula to calculations in Excel.

For example, you have the following timeline:

In column B with the time you use the formula B2 = A2 * 24, copy the remaining cells in column B, you will get the result of the hours as a decimal.

If you only want to get hours, you combine with the INT function to get the integer value:

Similarly, you change minutes and seconds by the formula:

C2 = A2 * 24 * 60 D2 = A3 * 24 * 60 * 60

Use the CONVERT function

Function syntax: = CONVERT (number, from_unit, to_unit)

Inside:

• CONVERT : is the name of the function used to convert
• Number : the original number to be converted.
• from_unit: unit of original number.
• to_unit: units to convert.

The value of the unit:

• "day" = if the unit is day.
• "hr" = units are hours.
• "mn" = units are minutes.
• "sec" = units are seconds.

For the above example, the default from_unit value is "day" , and if you want to change to hours / minutes / seconds then change to_unit to "hr" / "mn" / "sec" respectively. And you collect the same way as above.

Use the functions HOUR, MINUTE and SECOND

Another way to change hours to minutes, seconds; You can use the functions HOUR, MINUTE, SECOND to calculate the number of hours and minutes and use the sum calculation.

Function syntax:

= HOUR (serial_number) = MINUTE (serial_number) = SECOND (serial_number)

Where: serial_number is the number to be converted.

For the above example, you type the formula in turn as follows:

B2 = HOUR (A2) C2 = MINUTE (A2) D2 = SECOND (A2)

You copy the formula to the remaining lines in the cell to get the result:

To calculate the total number of minutes in column E, the formula will equal the number of hours * 24 + minutes + seconds / 60.

In cell E2 = B2 * 60 + C2 + D2 / 60. Copy the formula for the remaining rows in the column. You get the following result:

Good luck!