no your not doing anything wrong. the formula simply displayed it as days w/ 2 decimals. with what you want, it gets more comlicated. since dates can span more than a day, i did it like this:
change formula to (and i know, it's much longer
):
=(NETWORKDAYS(A1,B1))&" Days "&INT(((((NETWORKDAYS(A1,B1))+((B1-A1)-(NETWORKDAYS(A1,B1))-INT((B1-A1)-(NETWORKDAYS(A1,B1)))))-INT((NETWORKDAYS(A1,B1))+((B1-A1)-(NETWORKDAYS(A1,B1))-INT((B1-A1)-(NETWORKDAYS(A1,B1))))))*1440)/60)&" Hours "&ROUND((((((NETWORKDAYS(A1,B1))+((B1-A1)-(NETWORKDAYS(A1,B1))-INT((B1-A1)-(NETWORKDAYS(A1,B1)))))-INT((NETWORKDAYS(A1,B1))+((B1-A1)-(NETWORKDAYS(A1,B1))-INT((B1-A1)-(NETWORKDAYS(A1,B1))))))*1440)/60-INT((((NETWORKDAYS(A1,B1))+((B1-A1)-(NETWORKDAYS(A1,B1))-INT((B1-A1)-(NETWORKDAYS(A1,B1)))))-INT((NETWORKDAYS(A1,B1))+((B1-A1)-(NETWORKDAYS(A1,B1))-INT((B1-A1)-(NETWORKDAYS(A1,B1))))))*1440)/60),2)&" Minutes"
w/ "=date(2004,1,1)" in a1, and "=today()+0.167" in b1 (+0.167 for 4 hours - to test with), this is what you should see.
16 Days 4 Hours 0.01 Minutes
you can modify this in any way.
this formula should just give you hours w/ 3 decimal points.
=((INT((NETWORKDAYS(A5,B5))+((B5-A5)-(NETWORKDAYS(A5,B5))-INT((B5-A5)-(NETWORKDAYS(A5,B5))))))*24)+((NETWORKDAYS(A5,B5))+((B5-A5)-(NETWORKDAYS(A5,B5))-INT((B5-A5)-(NETWORKDAYS(A5,B5)))))-INT((NETWORKDAYS(A5,B5))+((B5-A5)-(NETWORKDAYS(A5,B5))-INT((B5-A5)-(NETWORKDAYS(A5,B5)))))
hope this helps you. sorry about the long wait.
edit: second formula i inserted four rows so all references are 5th row instead of 1st! - i'm sorry for the confustion