The answer I get is not correct
A1 10/10/08 16:30
b1 10/14/08 12:00 PM
The answer I get with this formula is 0 days,19:30:00 what am I doing wrong?
--
Linda


"Bob Phillips" wrote:

=NETWORKDAYS(A1,A2,holidays)-(MOD(A2,1)-MOD(A1,1)<0)&" days,
"&TEXT(MOD(MOD(A2,1)-MOD(A1,1),1),"hh:mm:ss")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Prema" wrote in message
...
A report was needed on 10/01/06 8:28:46. The delivery is on 10/30/06
16:17:20. Need to calculate the difference in days, hours and minutes, but
cannot take into weekends and holidays. Is there a way to do this?