In this tutorial, I will show you some really simple way to convert Number of Hours to Days in Excel.I will use two text functions (MOD and INT) to solve this challenge. The text functions are used to find Number of days from Hours and Extra hours left over.
Explanation Of Formula
The Excel MOD function which will be used looks like the following.
=MOD (number, divisor)
Here is brief explanation of what each function does in the formula.
- Number:The number to be divided.
- Divisor:The number to divide with.
- MOD : The Excel MOD function returns the remainder of two numbers after division. For example, MOD(10,3) = 1. The result of MOD carries the same sign as the divisor.
The Excel INT function which will be used looks like the following.
=INT (number)
To Convert Hours to Days in ExcelHere is Brief explanation of what each function does in the formula.
- INT : The Excel INT function returns the integer part of a decimal number by rounding down to the integer.Note the INT function rounds down,so negative numbers become more negative.For example, while INT(11.8) returns 11,INT(-11.8) returns -11.
- Number: The Number from which you want an integer.
Step 1: First we want to see what is days for respective hours so let’s assume cell A2 is 60(hours).Now we want Number of Days for 60 hours.So Use this formula in Cell E2.Look at Image for proper understanding.
Formula:=A2/24=2.5.
Step 2: Now we are interested in 2.5 in which 2 represent No of days and 0.5 represents extra hours (Number of days+extra hours) that is half a day.So now we will use INT function for days and MOD function for Extra hours.
Note:- INT gives us only integer part and MOD gives us Remainder.
Step 3: So Use this formula in cell E2 [=INT(A2/24)] so result will be 2 Now for extra hours use MOD function in cell F2 [=MOD(A2/24,1)] so result is 0.5 .Now 0.5 represents proportion of one 24 hour day so Multiply with 24 (0.5×24=12) So we get extra hours that is 12 .Final Result is 2 and half day.
Conclusion
There are lot of different ways to solve this problem with formulas.In this post we looked at two different formulas together used to Convert Hours to Days and Remaining Hours Left over.
Video about this topic:
Please leave a comment below If you have any questions or suggestions.I will reach out to you asap.Thank you!
