Add hour in time with condition

[Vishaal]

Excel 2019

In cell A1 we have timestamp
23/06/2018 12:02:18

No in cell B2 we want to add four hours in

but if timestamp is 23/06/2018 14:00:00 and office open and close time is 11:00 am to 5:00 pm then it will add four hours, according to office working hours 24/06/2018 13:00:00 and if Sunday then 25/06/2018 13:00:00

 

[Vishaal]

Thanks awoohaw, thanks for replying