Add TAT 'x' hours with the Start Time excluding Non-business days and hours

Hi,

I've an issue with complex criteria while adding a TAT hours with the Start Time.

Column D: Request In Time
Column F: TAT in hours (Turn Around Time)
Column G: Due Time (Which needs to be calculated. I.e: Result)

My team Shift Starts @ 06:30 PM and ends @ 06:30 AM.

I would like to add the TAT in hours with Request in Time by excluding the time outside my Shift hours and weekends.

It would greatly appreciated if you could help me with this.

Thanks a lot in advance.

Regards,

S. Praburam