Removing Weekends From a Formula...

[lee.bridle]

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

 

[Mike H]

Hi,

Try this

=(NETWORKDAYS(A2,B2)-1)+MOD(B2,1)-MOD(A2,1)

Firmkat as number to 2 decimal places.

Note that if you want this formula will acceot the Holidays argument

=(NETWORKDAYS(A2,B2,Holidays)-1)+MOD(B2,1)-MOD(A2,1)

Mike

 

[Jarek Kujawa]

try:

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

 

[DStrong]

The Networkdays function is part of the analysis tool pack. Be sure that is
installed or else you will get an error.