Using the NETWORKDAYS formula

[RaydenUK]

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.

 

[RonB1111]

Try:

=NETWORKDAYS(A2,B2)-1-MOD(A2,1)+IF(WEEKDAY(B2,2)<6,MOD(B2,1),TIME(23,59,0))

If this doesn't get your expected results, please post some sample data along with your expected results.