Calculating TAT Received and Completed tansk

[HECGroups]

Hello,

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)

 

[HECGroups]

can someone help me please