How do you know how many minutes a day or half is, or how many hours are five million seconds? This article provides an easy way to solve this problem.
Important Note: In this article, the second is the same as the second, the minute is the same as the minute, and the hour is the same as the hour.
Unit conversion: (conversion between different units such as time, distance, bits and bytes, etc.)
With Kutools, the Excel unit conversion plugin, you can quickly convert between multiple units without a formula.
Convert between hours, minutes, seconds or days with functions
1. Convert time to hours, minutes, seconds or days with the conversion factor
As we know, 1 hour = 60 minutes = 3600 seconds = 1.24 days. Therefore, the measurement of time can be converted by multiplying these factors.
Convert hours to seconds:
For example, to convert hours to seconds, enter the formula = A2 * 3600, and then drag the fill handle to the cells to get the results you need, see the image below:
If you want to convert seconds to hours, just enter this formula:
= A2 / 3600
Note: Convert between hours and minutes, day:
|Convert hours to minutes||
= A2 * 60
|Convert minutes to hours||
= A2 / 60
|Convert hours to days||
= A2 / 24
|Convert day to hour||
= A2 * 24
2- Convert time to hours, minutes, seconds or days with the Convert function
Hard to remember conversion factors? You can also use the Convert function to convert between hours, minutes, seconds or days.
To convert hours to seconds formula:
= CONVERT (A2, “hr”, “sec”)
Type to easily and simultaneously convert cells from hour to second. Note the following image:
If you want to convert seconds to hours, use this formula:
= CONVERT (A2, ”sec”, “hr”)
Note: Just replace the unit name in the formula to easily convert between time units.
|the unit||The name used in the formula|
Convert between hours, minutes, seconds or days with the Kutools Excel plugin
No need to maintain conversion rate and function, Kutools is an Excel unit conversion plugin that helps you easily do the conversions you want. ( Download here )
1. Select the desired range.
2. Click on Kutools> Content> Unit Conversion . Note the following image:
3- Like the image below, first select the desired unit from the drop-down box and then specify the source unit and the conversion unit to see the result in the Preview box.
4- Click on Ok or Apply. Time is converted from hour to minute as shown below:
Note: If you want to keep the source unit in cells and show the results in the comment, you can select Add results as comment . Note the following image:
Convert seconds: minutes: hours (hh: mm: ss) to minutes, seconds or hours with the formula
Sometimes you can format the time in the form of hours, minutes and seconds. In this case, you can use the following formulas to convert it to minutes, seconds or hours.
Convert format seconds: minutes: hours (hh: mm: ss) to hours:
Use this formula to convert hh: mm: ss to hours:
= HOUR (A2) + MINUTE (A2) / 60 + SECOND (A2) / 3600
Then drag the fill handle to the cells you want the formula to be applied to.
To convert hh: mm: ss format to minutes:
= ((HOUR (A2) * 60) + MINUTE (A2) + (SECOND (A2) / 60))
To convert hh: mm: ss format to seconds:
= HOUR (A2) * 3600 + MINUTE (A2) * 60 + SECOND (A2)
Convert seconds: minutes: hours (hh: mm: ss) to minutes, seconds or hours with the Kutools Excel plugin
Are you tired of formulas, so here is a useful and easy plugin called Kutools for Excel, with Convert Time feature, you can do it quickly and without any formulas.
After installing the Kutools plugin in Excel, follow these steps:
1. Select the time cells you want to convert.
2. Click on Kutools> Content> Convert Time , then select Time to Hours / Time to Minutes / Time to Seconds according to your needs, see the image below:
3- The selected time cells are converted to the hours, minutes or seconds you need, pay attention to the following image:
Note: If you want the converted result to be located in another location, you can select the type of conversion you want by clicking Kutools> Content> Convert Time in the Convert Time dialog box , and then check Save to another location. Select and click on the cell you want to get results from. See the image below: