How to convert hours to minutes in Excel

In this article, Software Tips will show you how to convert hours to minutes in Excel.

How to convert hours to minutes in Excel Picture 1

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:

How to convert hours to minutes in Excel Picture 2

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.

How to convert hours to minutes in Excel Picture 3

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

How to convert hours to minutes in Excel Picture 4

Similarly, you change minutes and seconds by the formula:

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

How to convert hours to minutes in Excel Picture 5

Use the CONVERT function

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

Inside:

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

The value of the unit:

  1. "day" = if the unit is day.
  2. "hr" = units are hours.
  3. "mn" = units are minutes.
  4. "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.

How to convert hours to minutes in Excel Picture 6

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:

How to convert hours to minutes in Excel Picture 7

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:

How to convert hours to minutes in Excel Picture 8

Good luck!

4.4 ★ | 9 Vote

May be interested

  • How to convert columns into rows and rows into columns in ExcelHow to convert columns into rows and rows into columns in Excel
    you 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 separatorHow to convert commas to dots in Excel - Convert unit separator
    in 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 ExcelHow to use the Convert function on Excel
    to convert a unit of measurement into excel, we will use the convert function.
  • How to convert PDF files to Excel keeps formattingHow to convert PDF files to Excel keeps formatting
    previously, 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, ExcelHow to convert Cad to Word, PDF, Excel
    after 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 ExcelExcel - Convert columns to rows in Excel
    if 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 ExcelHow to Convert Measurements Easily in Microsoft Excel
    excel'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 ExcelHow to round time to 30 minutes or 15 minutes in Excel
    we 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
    how 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 Successfully3 Ways to Convert CSV to Excel Successfully
    csv 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.