Buzz
In this article, Software Hacks will guide you on the process of transforming hours into minutes in Excel.
Using mathematical operations
Consider 1 hour = 60 minutes = 3600 seconds, apply this formula for calculations in Excel.
For example, suppose you have a time table as follows:
In column B, for calculating hours, use the formula B2=A2*24. Copy it for the rest of column B, and you'll get decimal hour results.
If you only want whole hours, combine it with the INT function to extract the integer value:
Similarly, convert to minutes and seconds using the following formulas:
C2=A2*24*60
D2=A3*24*60*60
Utilize the CONVERT function
Syntax of the function: =CONVERT(number,from_unit,to_unit)
Where:
- CONVERT: is the function name used for conversion.
- Number: the original number to be converted.
- from_unit: the unit of the original number.
- to_unit: the unit to convert to.
Values for the units:
- 'day' = if the unit is days.
- 'hr' = if the unit is hours.
- 'mn' = if the unit is minutes.
- 'sec' = if the unit is seconds.
In the given example, the default value for from_unit is 'day', and if you want to convert to hours / minutes / seconds, replace to_unit with 'hr'/ 'mn'/ 'sec' respectively. Obtain the result similarly to the method above.
Sử dụng hàm HOUR, MINUTE, SECOND
Another approach to convert hours to minutes, seconds is by utilizing the HOUR, MINUTE, SECOND functions to calculate the respective components and perform addition.
Function syntax:
= HOUR(serial_number)
= MINUTE(serial_number)
= SECOND(serial_number)
Where: serial_number is the number to be converted.
In the given example, input the formulas as follows:
B2 = HOUR (A2)
C2 = MINUTE (A2)
D2 = SECOND (A2)
Copy the formulas for the remaining rows in the cell to obtain the results:
To calculate the total minutes in column E, the formula is hours * 24 + minutes + seconds / 60.
In cell E2 = B2*60 + C2 + D2/60. Copy the formula for the remaining rows in the column. You will obtain the result:
Wishing you success!
