Calculating TAT Received and Completed task

Hello Again,

Referring to my post on Link

I need a formula to calculate turn-around-time (TAT). Find below the sample data and details for your reference.

Received Date & Time: 01-01-2015 10:02:00 PM
Completed Date & Time: 02-01-2015 09:07:32 AM
Business Hours: 08:00:00 AM to 10:00:00 PM
Non Business hours: 10:00:00 PM to 08:00:00 AM
Weekdays : Saturday to Thursday
Weekends: Friday's

If I calculate TAT for this time period it should show me 1 hour 5 minutes, why because business hours are closing by 01-01-2015 10:02:00 PM (Date/time), so it should not calculate duration after 10:00:00 PM to 08:00:00 AM the very next day.

However on Thursday night after 01-01-2015 10:02:00 PM I have received task and I completed on Saturday 02-01-2015 09:07:32 AM again it should calculate 1 hour 5 min only by skipping Thursday whole night and Friday whole day and night.

The above is an example might be I have completed the task in minutes or sends. It should calculate all time i.e. hours, minutes and seconds.

Received Date in column B (Format dd-mm-yyyy h:mm:ss AM/PM)
Completed Date in column S ((Format dd-mm-yyyy h:mm:ss AM/PM)

can someone help me please

After searching for hours I came upto below mentioned formula but it is calculating weekends also.

How can I exclude weekend i.e Friday.

Please Login or Register  to view this content.

Let say Thursday night I got a request on 01-01-2015 10:41:49 PM and I finished that request on 03-01-2015 8:31:30. So the TAT is 30:30.

But above formula is showing 14:31:30

Can someone help me please to solve this issue please.