Convert a number into days and hours

it seems that my original post got eaten by something or someone, so I will make a new short one.

I have a number that I want to convert into days and hours in the following format: x days y hours.

How do I do this.

Thanx in advance for the help

Neros

Hi Carim

I am very new to excel, so could you please tell me how to format the number into days and hours please.
Thanx for your quick answer.

Neros

The number will differ, but the actual number is 194, which is 8 days and 2 hours, but how to put it together?

If you have 194 in A1 use this formula in B1

=INT(A1/24)&" days "&MOD(A1,24)&" hours"

We are getting closer here, Daddylongleg - except for the MOD(A1,24)&" that must read MOD(A1;24)&" ... (I guess).

But the end result shows as 8 days 1,375 hours - I dont need the ,375 part tho - how do we get rid of that part (the hours changed in the meantime to 193 It is calculated from something else).


neros

Originally Posted by Neros

We are getting closer here, Daddylongleg - except for the MOD(A1,24)&" that must read MOD(A1;24)&" ... (I guess).

But the end result shows as 8 days 1,375 hours - I dont need the ,375 part tho - how do we get rid of that part (the hours changed in the meantime to 193 It is calculated from something else).


neros

My version of excel requires a comma in

=INT(A1/24)&" days "&MOD(A1,24)&" hours"

some versions require ; in place of , so, of course, yes, if that makes it work....

Note if A1 actually contains 193 then you'll get a result of

8 days 1 hours

If you get

8 days 1,375 hours

that means that A1 contains 193,375 (possibly formatted to only show 193). If A1 might not contain an integer try

=INT(ROUND(A1;0)/24)&" days "&MOD(ROUND(A1;0);24)&" hours"

This is just SO Perfect now, Daddylonglegs!
Thank you very much for your help!

Neros