In the Format Cells dialog, under Number tab, choose Time in the Category list, then go to right Type section, choose 37:30:55. Select the formula result then right click to select Format Cells from the context menu. If you want to display the time duration longer than 24 hours, you can format the time format as below: There are 24 hours one day, the decimal number divided by 24 will get the correct representation of hours in Excel. Select the results, then go to Number drop-down list under Home tab, choose Time. Press Enter key, then drag autofill handle over to cell C5. Here is a list of decimal number in cell B3:B5, in cell C3, type below formula to get the decimal time. If the argument decimal_hours is a negative value, the formula returns a string #. To display the decimal in a standard Excel time format, you need to format the result as a time.
DECIMAL HOURS TO HOURS AND MINUTES DOWNLOAD
If you want to follow along with this tutorial, please download the example spreadsheet.Īrguments Decimal_hours: the positive decimal number that you want to convert to Excel time. In Excel, there is a simple formula that supports to convert hours in the decimal format to a valid Excel time. Alternatively, just multiply 2.5 by 60 to get 150 minutes.Excel Formula: Convert Decimal Hours to Hours and Minutes 2.5 hours would equal 150 minutes since two hours times sixty equals 120 minutes, and 0.5 hours is 0.5 times sixty which is 30.
In this case, perform the conversion of decimal to time as usual, then simply multiple the number of hours by sixty and add any remaining minutes to the number. Oftentimes one wants to convert decimal time to minutes instead of hours and minutes. Subtract 15 from 135, then divide the result by 60 to get the number of hours. 135 modulo 60 will give us the number of minutes, in this case that is 15. Finding the modulo of two numbers means to find the remainder of a division. Since zero times anything is zero, the answer is simply eight hours.Įxample 3: 135 minutes is how many hours and minutes? To calculate the number of hours and minutes, the modulo mathematical operation needs to be used. Then multiply 0.00 by 60 to get the number of minutes. Solution: as above, write down 8 as the number of hours. So 5.50 in decimal equals 5 hours 30 minutes.Įxample 2: convert 8.00 decimal hours to time. Then multiply 0.50 by 60, which is the same as dividing it by two in this case, to get the number of minutes. Solution: write down 5 as the number of hours. Then multiply the fractional part by sixty to get the number of minutes.Įxample 1: convert 5.50 decimal hours to time. To convert decimal hours to time first write down the whole part of the decimal number down - this is the number of whole hours. Alternatively, if the decimal time is in minutes, enter the number of minutes, for example 125, to see it converted to hours and minutes: 2 hours and 5 minutes in this example. It is common for payroll hours to be expressed as a decimal, whereas sometimes you need to know how many hours and minutes that represents.įor example, enter 7.25 in decimal and the output will be 7 hours and 15 minutes. To use the tool, simply enter the decimal time and it will be converted to hours and minutes below.
0 kommentar(er)
