How to convert hours to minutes in Excel
In this article, Software Tips will show you how to convert hours to minutes in Excel.
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!
You should read it
- How to calculate time in Excel: Add and subtract time
- Why 1 minute has 60 seconds, 1 hour has 60 minutes and 1 day has 24 hours?
- How to convert Excel files to PDF online using Google Drive
- How to convert CSV files to Excel in bulk
- How to convert money into words in Excel, without an add-in, supports both 32-bit and 64-bit Excel
- How to convert PDF to Excel
- How to convert columns into rows and rows into columns in Excel
- How to use the Convert function on Excel
May be interested
- How to convert columns into rows and rows into columns in Excelyou need to convert excel columns into rows or convert data in excel rows into columns, if retraining takes a lot of time, just a trick that network administrator instructs below, you can turn the rows into columns or columns into rows extremely easy.
- How to convert commas to dots in Excel - Convert unit separatorin excel, to separate units in data, we can use periods or commas. so how to convert a period to a comma or vice versa?
- How to use the Convert function on Excelto convert a unit of measurement into excel, we will use the convert function.
- How to convert PDF files to Excel keeps formattingpreviously, tipsmake.com sent to you how to convert excel files to pdf. today, we will guide you to convert back, ie from pdf to excel, through online tools that are completely free and very easy to use smallpdf. please consult.
- How to convert Cad to Word, PDF, Excelafter designing cad drawings, you want to transfer cad to word, excel to print, present ... or you want to transfer cad to pdf so that any computer can read this file but don't know how to do it what? don't worry, the following article will guide you to transfer cad to word, pdf, excel very simply but not everyone knows it!
- Excel - Convert columns to rows in Excelif you have an excel file and enter data in the wrong row or column or vice versa, what will you do? would you delete it and re-enter it? that takes up a lot of your time. let's see how taimienphi.vn guides you on how to convert columns into rows in excel.
- How to Convert Measurements Easily in Microsoft Excelexcel's convert function ('=convert()') converts a measurement from one unit to another. to use this function, you will enter data and units into the formula: =convert(number, 'from_unit', 'to_unit'). first learn how to enter the convert...
- How to round time to 30 minutes or 15 minutes in Excelwe can set rounding time in excel to 30 minutes or 15 minutes to make it easier to calculate and synthesize.
- How to convert a CSV file to Excelhow to convert a csv file to excel. csv stands for comma separated values, which is a simple text format where values are separated by commas. both csv and excel are files that help store data in spreadsheets. however, csv also has advantages and disadvantages compared to excel software. t
- 3 Ways to Convert CSV to Excel Successfullycsv is a popular data format but it is not easy to work with without the right tools. this article will guide you through the simple and optimal way to convert csv to excel, helping you quickly summarize data.