# How to Convert Hours to Days in Excel (6 Effective Methods)

Get FREE Advanced Excel Exercises with Solutions!

Working on time schedules for different purposes has become easier with excel. It helps to convert hours to days and vice versa in many different ways. Also, we can convert between all types of time and day formats in excel. In this article, we will discuss how to convert hours to days in excel with 6 effective methods. So without any delay, let’s go for it.

## 6 Effective Methods to Convert Hours to Days in Excel

Let us take an example for illustration. The dataset below shows a Project Schedule from beginning to end. Along with it, we can see the Working Hours of each phase in the schedule. As you can see, the hours’ information is not entirely understandable as they are more than 24 hours. Therefore, we will convert them to days for clarification following the methods below.

### 1. Use CONVERT Function to Convert Hours to Days

This first method will guide you in converting hours to days with the CONVERT function. This function is applicable for switching from one measurement unit to another. Let’s see how it works.

• First, select cell D5 and insert this formula.
`=CONVERT(C5,"hr","day")` • Next, press Enter.
• Here, you will see the first value of Working Days. Here, we used the CONVERT function to transfer the hour values into days. Keep in mind that, it will only convert them to decimal values.

• Following, use the AutoFill tool to apply this formula in cell range D6:D10. Additional Tip: For other units of time measurement, use these texts for each conversion in formulas.
• Year = “yr”
• Day = “day”
• Hour = “hr”
• Minute = “mn”
• Second = “sec”

### 2. Convert Hours to Days by Combining INT & MOD Functions

In this method, we will convert working hours to separate days and hours as all the values are more than 24 hours. For this, we will combine the INT and MOD functions. It will also eliminate the decimal values that we faced in the first method. Follow the process below:

• First, insert a new column titled Additional Hours. • Then, insert this formula in cell D5.
`=INT(C5/24)` • Next, hit Enter and you will see the value in Days. Here, we applied the INT function for converting the number in cell D5 to an integer.

• Following, insert this formula to get the rest of the hours apart from days.
`=MOD(C5/24,1)*24` • Next, hit Enter to get the output. Here, we used the MOD function for finding a remainder from cell C5 after dividing by 24.

• Lastly, select cells D5 and E5 and drag the bottom corner up to cell E10. • That’s it, you have a precise output of Working Days with Additional Hours.

### 3. Apply FLOOR Function for Converting Hours to Days in Excel

At this stage, let us try another method for converting hours to days. Here, we will apply the FLOOR function to get the value nearest to zero. Following are the steps:

• First, select cell D5 and insert this formula.
`=FLOOR(C5/24,1)` • Then, hit Enter.
• Here, you will see the first value of Working Days. As you can see, the cell is only showing a round-up value because of using the FLOOR function.

• Lastly, use the Fill Handle tool for getting the result in cell range D6:D10. ### 4. Insert QUOTIENT Function for Conversion of Hours to Days

So far, we saw only numeric values while converting hours to days. Now, we will insert the QUOTIENT function to discard the remainder and return the integer portion. Let’s see how it works.

• In the beginning, type this formula in cell D5.
`=QUOTIENT(C5,24)&IF(C5/24<2,"Day","Day")&MOD(C5,24)&IF(MOD(C5,24)<2,"Hour","Hours")` • Afterward, hit Enter to get the output. In the formula, we used the IF function to establish the logical condition based on 24 hours on cell C5. Then, applied the MOD function to get the remainder from the reference cell. Lastly, gathered them with the QUOTIENT function to return the integer position.

• Lastly, drag the bottom corner of cell D5 up to cell D10 for converting hours to days for each activity. Additional Tip: Use this formula in case of 8-hours converting to days.

`=QUOTIENT(C5,8)&"days"&((C5/8)-QUOTIENT(C5,8))*8&"hours"`

### 5. Convert Hours to Days in Excel with INT Function

In this fifth method, we will use the INT function independently for converting hours to days. Here is the detailed process:

• First, type this formula in cell D5.
`=INT(INT(SUBSTITUTE(C5,"hr","")/24))&"days"&""&INT(MOD(SUBSTITUTE(C5,"hr",""),24))&"hours"` • Next, hit Enter.
• Now, we can see that the hour in cell C5 is converted to days and remainder hours like this: Here, we applied the INT function to get an integer value and the MOD function to find the remainder from cell C5. Along with it, we also used the SUBSTITUTE function to replace text with days and hours.

• Lastly, use AutoFill to apply the similar formula in cell range D6:D10. ### 6. Apply IF Function for Converting Hours to Days

In this last method, we will combine all the functions we used so far led by the IF function. Let’s see how it works.

• First, insert this formula in cell D5.
`=IF(MOD(SUBSTITUTE(SUBSTITUTE(C5,"hrs",""),"hr",""),24)>=24,ROUND(SUBSTITUTE(SUBSTITUTE(C5,"hrs",""),"hr","")/24,0),FLOOR(SUBSTITUTE(SUBSTITUTE(C5,"hrs",""),"hr","")/24,1)&"Day "&MOD(SUBSTITUTE(SUBSTITUTE(C5,"hrs",""),"hr",""),24)&"Hours")`
• Following, press Enter to get the result. Here, the IF function defines the condition that cell C5 will show results within 24 hours. Then, the ROUND function rounds the number keeping the remainder with the MOD function. Following, we used the FLOOR function for avoiding any fractional value. Lastly, we applied the SUBSTITUTE function for replacing text with time units.

• Lastly, drag the bottom corner of cell D5 up to cell D10 for getting the final conversions. ## Things to Remember

• You don’t need to convert the cells into Date format. Otherwise, it will show a false value.
• You can apply any of the methods above other than 24 hours as well.

## Conclusion

Concluding the article with the hope that it was a helpful one for you on how to convert hours to days in excel with 6 effective methods. Let us know if you have any suggestions on this. Follow ExcelDemy and keep learning excel.

## Related Articles #### Sanjida Mehrun Guria

Hello! Welcome to my blog. I have completed my Bachelor in Architecture from Ashanullah University of Science & Technology, Dhaka. I am a passionate, goal-oriented person with an immense thirst for knowledge and an attitude to grow continuously. Besides Architectural work, I find it very enthusiastic to work in Excel blogging. Exceldemy is a platform where I have got the opportunity to flourish my skill in Microsoft Excel and therefore, here I will be posting blogs related to it.

1. Reply This is stupid. If Working hours are 50, than Working Days are not 2. This assumes a work day is 24 hours long. The calculation should consider that a Working day varies from 7-12 hours.

• Reply Sanjida Mehrun Guria Apr 13, 2023 at 12:30 PM

Hello Nah,
Thanks for your feedback. As mentioned in the article, you can try any of the methods for your preferred hours. Only the CONVERT function cannot do that because it is built to perform on standard time format. Therefore, please check the attached Excel file where the working day is considered 8 hours/day.
Thank you.

Regards,
Sanjida Mehrun Guria
Excel VBA & Content Developer
ExcelDemy Advanced Excel Exercises with Solutions PDF  