Calculation of working hours between two dates & times

[AShahid]

I want to calculate the response time during working hours between two dates & times.

Scenario 1: A request comes in at 10:00 on 19/9/2018 and I respond at 11:00 on same day i.e. 19/9/2018
Scenario 2: A request comes in at 11:30 on 19/9/2018 and I respond at 10:30 next day i.e. 20/9/2018
Scenario 3: A request comes in at 22:00 on 19/9/2018 and I respond at 10:30 next day i.e. 20/9/2018

Working Hours are:
Start Time: 9:00
End Time: 17:30
Working Days are Monday to Friday (both inclusive)

I have a database with separate columns for dates and different columns for times.
I just want to calculate the elapse time between request arrival to request responded. (only hours & minutes to be calculated which fall during the working days and working hours)

 

[James006]

Hello,

Searching in the Forum for previous threads ...

Look for Barry 's proposals ...!!!

https://www.mrexcel.com/forum/excel...tion-exclude-non-business-hours-weekends.html

HTH