Using the NETWORKDAYS formula

I am using the formula =NETWORKDAYS(A2,B2)-1-MOD(A2,1)+MOD(B2,1) where A2 is the start date and B2 is the end date. The NETWORKDAYS function works fine by ignoring the weekend days, however, if the end date is on a weekend then the formula doesn't work, it just gives ########. Is there a way to modify this formula to say that if the end date is on saturday at 8am, for example, then the result would reflect the time ending on Friday at 11:59pm? Therefore, if the start date is Friday at 8am then the cell would say "15:59", since it is only calculating from 8am to 11:59pm on friday, while ignoring saturday.

Got to thinking about my last post formula... could be shortened to...

Formula:

Please Login or Register  to view this content.