try:

=IF(WEEKNUM(B2)WEEKNUM(A2),B2-A2-2,B2-A2)


On 10 Gru, 12:54, wrote:
OK, so, I have the following data:

Batch Start Date and Time - 10/12/08 14:00
Batch Finish Date and Time - 15/12/08 16:55
Batch Duration - =SUM(B2-A2) Which supplies me with the answer: 5.12

However, we shut down over the weekend, so I need to remove the
weekend from the answer, which would give me 3.12.

Trying to do this using Networkdays doesn't seem to include the hours,
so I just get the answer 4, as it touched 4 working days.

Anyone know of something that could help me?

Thanks in advance!

Lee