Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

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.


Download Practice Workbook

Download this practice file and try it yourself.


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.

How to Convert Hours to Days in Excel


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")

Use CONVERT Function to Convert Hours to Days

  • 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.

Use CONVERT Function to Convert Hours to Days

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”

Read More: How to Convert Minutes to Hours and Minutes in Excel


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.

Convert Hours to Days by Combining INT & MOD Functions

  • 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

Convert Hours to Days by Combining INT & MOD Functions

  • 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.

Read More: Convert Seconds to Hours and Minutes in Excel (4 Easy Methods)


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)

Apply FLOOR Function for Converting Hours to Days in Excel

  • 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.

Apply FLOOR Function for Converting Hours to Days in Excel

Read More: Convert Decimal Coordinates to Degrees Minutes Seconds in Excel


Similar Readings


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")

Insert QUOTIENT Function for Conversion of Hours to Days

  • 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.

Insert QUOTIENT Function for Conversion of Hours to Days

Additional Tip: Use this formula in case of 8-hours converting to days.

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

Read More: How to Convert Minutes to Tenths of an Hour in Excel (6 Ways)


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"

Convert Hours to Days in Excel with INT Function

  • 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.

Read More: How to Convert Seconds to Hours Minutes Seconds in Excel


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.

Read More: Excel Convert Seconds to hh mm ss (7 Easy Ways)


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

Guria

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.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo