Trying to create dynamic date/time formula

Hello experts,

I am trying to create a formula that adds the hours from column J to the Start date/time in column I to produce the End/Completion date/time in column K, but only counting hours between certain times of the day and excluding weekends/holidays. Please see the attached file, any help is greatly appreciated.

Best Regards,

Ray

Try:
=WORKDAY(I4,CEILING(ROUND(1440*(J4/24+MOD(I4,1)-C$9)/(C$10-C$9),0)/1440,1)-1,$B$13:$B$19)+ROUND(1440*(MOD(I4,1)+J4/24),0)/1440-CEILING(ROUND(1440*(MOD(I4,1)+(J4/24-C$9)),0)/1440,ROUND(1440*(C$10-C$9),0)/1440)+C$10-C$9

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.