Exclude Sunday and Pub holiday

Hi I had this in the Functions sections, but after lots of views no one seems to know if this doable. So i was hoping some coding person could help as i have no idea of how to write code



Hi I have a calculation, several in fact and basically they check when a test comes in and when it is released. It's measured over 24 hrs, 48 hrs ,72hrs and 72+ hrs.
I use this to work out the interval
=(D2+E2)-(B2+C2)

This is what pulls the number into the time period
=COUNTIFS('Raw data'!F2:F1667,">01:00",'Raw data'!F2:F1667,"<=24:00")

So where my problem is that no-one works Sunday or Public holidays, so if a case comes in Friday after noon goes monday afternoon showing as 72 hrs where in effect its should be showing as 48 hrs.
Is there away that case that run over a Sunday or pub holiday take those hours of?

I have attached the file just in case you more clarification.

Any help is really appreciated, i am right under the pump now/