Formatting Formula Results
 

OK, Tom suggested that I use This site ------
http://www.cpearson.com/excel/DateTimeWS.htm in order to try to achive
what I was wanting to do. Well I finally figured out how to get it to
calculate but the result is not formatting to the way that I want it.

Here's what i'm looking at....

Col C Col D Col E
Row 9 08-28-06 2:28 PM 08-28-06 3:25 PM 0 days 0.95 hours ' Derrived from
this code -- =IF(D9<FALSE,IF(AND(INT(C9)=INT(D9),NOT(ISNA(MATC H(INT(C9),
HolidayList,0)))),"0 days 0 hours", IF(INT(C9)=INT(D9), "0 days " &
ROUND(24*(D9-C9),2)&" hours ", MAX(NETWORKDAYS(C9+1,D9-1,HolidayList),0)+
INT(24*(((D9-INT(D9))-(C9-INT(C9)))+
(DayEnd-DayStart))/(24*(DayEnd-DayStart)))& " days
"&MOD(ROUND(((24*(D9-INT(D9)))-24*DayStart)+
(24*DayEnd-(24*(C9-INT(C9)))),2), ROUND((24*(DayEnd-DayStart)),2))&" hours
")),"")

I need Col E to be formatted like this..... 0 Days 9 Hours 16 Minutes

I keep trying to set the format of the cells to it by using this.... d" Days
"h" Hours "mm" Minutes"

What am I doing wrong and why is it showing decimal values???

I'm also trying to add the total of every tenth row by using this....
=IF(E9<"",SUM(E9:E18),"") but for some reason i won't add, I keep getting
zeros. All this started by me using the suggested code to enable me to
account for the hours that are only working hours. The code works perfectly
in that respect but now I can't figure out the rest.

Please help.
Thanks in Advance,
Rob