Response times in Excel

Kelly Denise Horton
Kelly Denise Horton used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
What for example does "19:01:49" represent? Hours/minutes/seconds?
Kelly Denise HortonConfiguration Management Analyst

Author

Commented:
yep, hours:minutes:seconds
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
So did that user respond in 19+ hours or 1 minute and 30 seconds?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Kelly Denise HortonConfiguration Management Analyst

Author

Commented:
1 minutes and 30 seconds.  Sorry if my chart is confusing.
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

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

Author

Commented:
i don't know what that is, but if it's easy to understand and translate....yes
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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 HortonConfiguration Management Analyst

Author

Commented:
oh ok.  let's try it.
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Slight change.
29008425a.xlsm
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Hmmm. I just thought about user CC. Is that the next day?
Kelly Denise HortonConfiguration Management Analyst

Author

Commented:
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?
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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 HortonConfiguration Management Analyst

Author

Commented:
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!!!!
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Here's an update.
29008425b.xlsm
Kelly Denise HortonConfiguration Management Analyst

Author

Commented:
thank you sooooo much!!!!  I was able to get this to work.
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Please don't forget to close this question.
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial