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