# Response times in Excel

Hi, I've been testing with users and recording their response times during the period of an hour and a little bit after that hour.  Now that i have the exact response times, I'm trying to figure out the correct formula to calculate the percentage of response times after 15, 30, and 60 minutes in Excel.  Does anyone have any thoughts?

Attached is my chart
Atl-Time-Test.xlsx
Martin Liss

What for example does "19:01:49" represent? Hours/minutes/seconds?

yep, hours:minutes:seconds
So did that user respond in 19+ hours or 1 minute and 30 seconds?

1 minutes and 30 seconds.  Sorry if my chart is confusing.
No problem I just wanted to make sure. Is a solution that involves user defined function  (in other words VBA code) OK?

i don't know what that is, but if it's easy to understand and translate....yes
What it means to you is that you'd have to save the workbook as an xlsm file rather that an xlsx file. Other than that it would be like using any other formula.

oh ok.  let's try it.
Double check these percents. They represent the number of values greater than or equal to 15 minutes (for example), divided by the number of rows (ignoring the header, row 2 and and the row that contains "Test End".
29008425.xlsm
Slight change.
29008425a.xlsm
Hmmm. I just thought about user CC. Is that the next day?

I was wrong....instead of calculating after 15, 30, and 60 mins....I need to figure out the percentages of those that responded within those times (within 15 mins, within 30 mins, within 60 mins).  Does that change the formula at all?
My percents should show the results for 0 to 15.0 minutes, 0 to 30.0, and 0 to 60 minutes.

If you want 0 to 15.0 minutes, >15.0 to 30.0, and >30.0 to 60 minutes then let me know.

could you do the 0 to 15, 15 to 30 and 30 to 60?  I've been wracking my brain and I just can't figure this out!!!!
Martin Liss

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.