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)
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)