Convert Hours to Days

[Robby19]

Hello,

I have a table the looks like the following;

Jan	Feb	Mar	Total
	11.75	6.00	17.75
21.50	19.75		41.25

<TBODY>
</TBODY>

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.