Trying to remove weekend days from calculation

[MatthewIJClark]

I need help with the following please.

I've got a report where we do 24 hour call back to customers but it's failing callback we've received late on a Friday and we don't return to the office until Monday morning. The report includes the Saturday and Sunday.

So my first cell has:

06/02/2016 11:36:00

With are taking the following from the above:

08/02/2016 10:28:00

And getting the following:

46:52:00

I need to try and remove the Saturday and Sunday from the calculation, I thought workday might do this but I'm getting confused with playing around with it.

All help greatly appreciated.

TY

[BadlySpelledBuoy]

Have a look at =NETWORKDAYS(). It might help you out here.

BSB

[Phuocam]

A1 : Start_date
B1: End_date
Try: =MAX(0,NETWORKDAYS(A1,B1)-1-MOD(A1,1)*(WEEKDAY(A1,2)<6)+MOD(B1,1)*(WEEKDAY(B1,2)<6))