Kelly Denise Horton
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
Atl-Time-Test.xlsx
Attached is my chart
Atl-Time-Test.xlsx
What for example does "19:01:49" represent? Hours/minutes/seconds?
ASKER
yep, hours:minutes:seconds
So did that user respond in 19+ hours or 1 minute and 30 seconds?
ASKER
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?
ASKER
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.
ASKER
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
29008425.xlsm
Slight change.
29008425a.xlsm
29008425a.xlsm
Hmmm. I just thought about user CC. Is that the next day?
ASKER
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.
If you want 0 to 15.0 minutes, >15.0 to 30.0, and >30.0 to 60 minutes then let me know.
ASKER
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!!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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