Avatar of Kelly Denise Horton
Kelly Denise Horton
Flag 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
Atl-Time-Test.xlsx
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon
Martin Liss

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

ASKER
yep, hours:minutes:seconds
Martin Liss

So did that user respond in 19+ hours or 1 minute and 30 seconds?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Kelly Denise Horton

ASKER
1 minutes and 30 seconds.  Sorry if my chart is confusing.
Martin Liss

No problem I just wanted to make sure. Is a solution that involves user defined function  (in other words VBA code) OK?
Kelly Denise Horton

ASKER
i don't know what that is, but if it's easy to understand and translate....yes
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

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.
Kelly Denise Horton

ASKER
oh ok.  let's try it.
Martin Liss

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
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Martin Liss

Slight change.
29008425a.xlsm
Martin Liss

Hmmm. I just thought about user CC. Is that the next day?
Kelly Denise Horton

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?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

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.
Kelly Denise Horton

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
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Kelly Denise Horton

ASKER
thank you sooooo much!!!!  I was able to get this to work.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Martin Liss

Please don't forget to close this question.
Martin Liss

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