How do I calculate time between 2 dates/times subtracting the time over weekends?

I have 2 cells that I want to find the amount of time between (d:hh:mm)

My dates are formated like this: Saturday January 24, 2009 12:11PM (DayofWeek mmmm,dd,yyyy hh:mm AM/PM)

The catch is that if the times span over a weekend, I don't want to include the 48H of the weekend?

ie. If I have:
Date #1: Friday, Jan 23, 2009 4:00 PM
Date #2: Tuesday Jan 27, 2009 2:00PM

Would normally be: 190h

But I want to automatically subtract the 48h of the weekend whenever this occurs

Thus the answer I want is: 142h

I have a few hundred of these and want to be able to figure it out - any help would be greately appreciated

use the =NETWORKDAYS() function its designed for just that
http://support.microsoft.com/kb/259200

Hi

Try this page on C Pearsons site which goes into what you want in detail.

HTML Code: 

Regards

Jeff

I'd say there are 94 hours between those 2 timestamps, when you take off 48 hours over the weekend the result would be 46

If start time/date is in A1 and end time/date in B1 then try this formula in C1

=NETWORKDAYS(A1,B1)-1+MOD(B1,1)-MOD(A1,1)

format C1 as [h]:mm to give result 46:00

If you want the result as a decimal, i.e. 46 then multiply by 24 i.e.

=(NETWORKDAYS(A1,B1)-1+MOD(B1,1)-MOD(A1,1))*24

format as number

In either case I'm assuming that start and end times will always be on weekdays. If that isn't the case, i.e. if start and end dates could be at the weekend then you need a slightly more complex formula.....