Link to home
Start Free TrialLog in
Avatar of Kelly Denise Horton
Kelly Denise HortonFlag for United States of America

asked on

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
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

What for example does "19:01:49" represent? Hours/minutes/seconds?
Avatar of Kelly Denise Horton


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".
Slight change.
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!!!!
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thank you sooooo much!!!!  I was able to get this to work.
Please don't forget to close this question.
You're welcome and I'm glad I was able to help.

If you expand the “Full Biography” section of my profile you'll find links to some articles I've written that may interest you.

Marty - Microsoft MVP 2009 to 2016
              Experts Exchange MVE 2015
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2016