Convert Hours to Days

[Robby19]

Hello,

I have a table the looks like the following;
[TABLE="width: 500"]
<TBODY>[TR]
[TD]Jan
[/TD]
[TD]Feb
[/TD]
[TD]Mar
[/TD]
[TD]Total
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]11.75
[/TD]
[TD]6.00
[/TD]
[TD]17.75
[/TD]
[/TR]
[TR]
[TD]21.50
[/TD]
[TD]19.75
[/TD]
[TD][/TD]
[TD]41.25
[/TD]
[/TR]
</TBODY>[/TABLE]
These are total hours calculations.

How do I convert the Total column to days? I got the Total/24, but I need it to look like the following. For example, 17.75 should read 18 Hours and 41.25 should read 1 Day XX Hours (pardon my math )

 

[Nishant94]

Unknown
	A	B	C	D	E
1	Jan	Feb	Mar	Total
2		11.75	6	17.75	0 Days and 18 Hours
3	21.5	19.75		41.25	1 Days and 18 Hours
Sheet1

Cell Formulas
Range	Formula
E2	=INT(D2/24)&" Days and "&ROUNDUP(MOD(D2,24),0)&" Hours"

 

[Robby19]

This is great! One last question. Is there a way to total the data in this column to show an overall amount of time, for example with the above calculation it should read "2 Days and 12 Hours."

 

[Robby19]

Just kidding. I'm an idiot. I can just total the Total column and use this same formula for that. Don't mind me.