I have an excel table with information below:

E: Date and time in MM/DD/YY HH:MM format  

H: # of Hours  

I: Expected completion time in MM/DD/YY HH:MM format

I is E+H and skipping weekend and holidays, the formula is

```
=IFERROR(WORKDAY(E5,H5/24,Holidays!$A$2:$A$37)+MOD(E5,1)+MOD(H5,24)/24,"")

```

But if the result return a time within 00:00 - 09:00, I would like to change the time to 11:30, otherwise, keep it as it is

For example: 

If the result is 03/05/19 03:52, then change the time to 03/05/19 11:30 

If the result is 03/05/19 22:00, then keep the time as 03/05/19 22:00 

The time would keep as 11:30 no matter what the original time is

I was trying this formula but it is not working:

```
=IF(WORKDAY(E5,H5/24,Holidays!$A$2:$A$37)+MOD(E5,1)+MOD(H5,24)/24>WORKDAY(E5,H5/24,Holidays!$A$2:$A$37)+MOD(E5,1)+TIME(23,30,0),WORKDAY(E5,H5/24,Holidays!$A$2:$A$37)+MOD(E5,1)&TIME(11,30,0),WORKDAY(E5,H5/24,Holidays!$A$2:$A$37)+MOD(E5,1)+MOD(H5,24)/24)

```

Could anyone help me on this? Appreciate for your help!