Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate with formula results after formatting with =TEXT | Excel Worksheet Functions | |||
formatting columns with formula results | Excel Programming | |||
Formatting the Results of VLOOKUP | Excel Worksheet Functions | |||
formatting results from mysql query | Excel Programming | |||
Formatting zero results from a formula | Excel Programming |