Help with Formula

[Steven1985]

Hi,

I have a current formula (Below) thats countS the date and time in HH:MM from one cell (A3) to (AO3).

This has included NETWORKDAYS to exclude counting if a weekend of bankholiday. This data is in Controls A10:A47

=IF(AO3="","",NETWORKDAYS(A3,AO3,Controls!A$10:A$47)-1-(MOD(A3,1)>MOD(AO3,1))&" days "&TEXT(AO3-A3,"h:mm"))

The issue I have is -

Date Received (A3) 02/09/2011 09:00 Outcome Date (AO3) 03/09/2011 11:15

Currently the formula would bring back -1 Days 21:15

I need it to ignore all of the 02/09/2011 as it's a sunday (a non working day) and count from 9am Monday 03/09/2011 so i want it to read 0 Days 2:15??

Is this even possible?

Many Thanks

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=582226

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).