Find End Date and Time with Working Hours and Duration

[James006]

Hi,

Say Working Hours are defined as follows :
Mornings F2:G2
AfterNoons F3:G3

In cell A2, there is the Start Date and Time
In cell B2, there is a project duration expressed in hours

My Objective is to get the End Date and Time in cell C2

Thanks in advance for your help

Cheers

 

[imaad]

A2 start_date, 27/02/2017 08:00:00 AM

B2 Workdays, 28/02/2017 05:00:00 PM

C3 end_date and time required, (excluding weekends and holidays)