Turnaround time

[justnotsure]

FORMULA OVERLOAD

We are trying to track turnaround time on request placed .We need to remove holidays and weekends. A typical deposit date 2021-04-20 2:15:00 PM and a typical completion date 2021-04-22 11:00:00 AM need to calculate turnaround days and hours . Part two if a request comes in after 1.00 pm we need to start day one the following day the formula we are working with is
=(NETWORKDAYS.INTL(B7,D7,1,Holidays!F$2:F$12)-1)*("17:00"-"9:00")+IF(NETWORKDAYS.INTL(D7,D7,1,Holidays!F$2:F$12),MEDIAN(MOD(D7,1),"17:00","9:00"),"17:00")-MEDIAN(NETWORKDAYS.INTL(B7,B7,1,Holidays!F$2:F$12)*MOD(B7,1),"17:00","9:00")

Just not working to calculate to start the next day our work day is 9 to 5

Thank you for any help

 

[Sulprobil]

A similar problem has been solved here:

Calculate Response time using different working hours during the week and excluding weekends / bankholidays

Hello I need a formula where it calculates Response Time considering business hours Mon - Thu 9am till 9pm and Fri 9am-5pm. In addition Bankholidays and Weekends should be excluded. Ticket Received Date is shown in Column B , Call Date is shown in Column C. Formula for Response Time for...

www.mrexcel.com