How To Convert Minutes To Hours Minutes Seconds In Excel

In column a we have minutes we need to convert the number of minutes to hours in column b. In the opening convert time dialog box specify one conversion type in the convert type section check the save to another location option and then specify the destination range in the save to box. Select a blank cell for instance cell b1 enter this formula a124 in the cell the cell a1 indicates the cell you want to convert its data to decimal time you can change it as.
how to convert minutes to hours minutes seconds in excel

See below for how to apply it to all cells in the column.

How to convert minutes to hours minutes seconds in excel. Kutools for excels convert time feature can help you to convert multiple time format to hours minutes or seconds as you wanted. Type b31440 in the formula bar then press enter to convert the hours and minutes into minutes. The second argument in the convert function is fromunit which is mn for minutes. Converting minutes to hours in order to convert minutes to hours we simply divide the number of minutes by 60 because there are 60 minutes in every hour.

In the third argument enter or select tounit as hr for hour. Select the range of time data that you will convert to secondsminuteshours and then click kutools content convert time convert time. To get the hour value from the minute value divided by 60 number of minutes in one hour and to get an hour value from the second value divided by 3600 number of seconds in one hour. We enter minutes in cell a3 in cell b3 enter this formula a360.

Applying the above formula. Supposing you have a list of time in hours minutes and seconds formatting in column a and to convert them to decimal time you just need to follow these steps. The time value consists of hour minute and second value. Please type this formula converta2hrsecto easily convert cells from hours to seconds at once.

Click to download and free trial kutools for excel now. To convert hours to seconds. Click in the c3 cell and grab the bottom right handle of the cell marker it turns to a sign when youve grabbed it correctly and drag it down the other cells in column c. You can use the convert function to convert tween hour minutes seconds or days too.

With more than 300 handy excel add ins free to try with no limitation in 30 days. Download and free trial now. Converting decimal time to hours using the convert function we can also use a convert function to get the number of hours from decimal time. Hour a1 minute a160 second a13600 if we want to convert hours to a decimal chart we can do a reverse of what we have done in the process above.