Calculating working time between 2 dates minus weekend

I have 3500 of these to do so a formula solution would be really appreciated.

Cell A1 - 06/03/2007 10:00
Cell B1 - 14/03/2007 14:00

I need the difference between these two taking into account that my working day is 08:00-18:00 and I do not work weekends.


I think it can be done using NETWORKDAYS but I cant figure out how to calculate the 2 part days.
The following gives me the 50 hours Wed/Thu/Fri/Mon/Tue
=((NETWORKDAYS(A1,B1)-2)*("18:00"-"08:00"))*24

See my attachment for a manual calculation of my problem.

Thanks

langered

As Reafidy pointed out you have failed to follow the rules of this site & ozgrid

See the links below for forum rules