Go Back

Issue response time calculation

If you need to calculate a response time based on priority level, you can create a table with status and apply VLOOKUP. This tutorial will show you how to issue response time calculation with a detailed example.

Formula

=Xn+VLOOKUP(value, table, column, FALSE)

Explanation

In this formula, Xn represents any cell that can be A1, B3 or any other in the Excel sheet.

VLOOKUP function accepts four arguments here.

  • The first argument is the value that is to be searched for in the vertical column passed in 2nd argument.
  • After the entry is found in the vertical table, 3rd argument defines the index of the column from which the entry is to be returned as a result.
  • The last argument is FALSE, which makes it able to find the exact match from the lookup table

Example 

Firstly, we will go through a sample that time has been considered each with its specific priority level. The maximum response time is specified separately for each priority level from 1 to 5.

Figure1. Sample sheet for calculating and issuing the response time

Calculating the response time in cell B3, with the priority level in C3, VLOOKUP searches for the priority level in the array F3 to G7  and corresponding response time is added to it. Enter the following formula in cell D3.

=B3+VLOOKUP(C3,F3:G7,2,FALSE)

Figure2. Entering the formula in D3 to calculate the response time

Finally, the result shows the priority set for each entry as below:

Figure3. Issuing the calculated response time

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

Formula issue. Countifs + sum of calculation.
Solved by C. C. in 24 mins
I have 2 separate files, one with clock in and out times for employees, and another with customer response times per customer. I want a way to average all of the response times per employee during the time that they are clocked in. The response time information is time stamped.
Solved by T. F. in 17 mins
I needed help with a calculation that finds the difference between two times. I have two cells one with a start time and one with a end time which then calculates the difference and puts the total run time down below in a different cell. I use the formula =TEXT(Q5-Q4, "h:mm:ss") only issue I have is when its a night shift calculation say start time is 5:30 pm and end time is 1:20 am it can not calculate that difference. The formula does work for a day shift calculation though.
Solved by X. D. in 19 mins

Leave a Comment

avatar