Turn around Time

  • Thread starter instereo911 via OfficeKB.com
  • Start date
I

instereo911 via OfficeKB.com

Good morning,

I have a workbook and my goal is to see when a number is no longer on the
sheet.

My workbook looks like this

A B
1 05/01/2007 25235
2 05/01/2007 68325
3 05/01/2007 78932
4 05/02/2007 68325
5 05/02/2007 11123
6 05/03/2007 99823
so on and so forth

I need to get an average of how many numbers were closed within 1 day, how
many were closed within 2 days, etc.

In this instance, I would say 5 total numbers, 4 closed within 1 day, 1
closed within 2 days

Hopefully this is possible... I have a sheet with a months worth of numbers.

Thanks again everyone.
 
G

Guest

The only thing I can figure is that column B is how many "seconds" it took to
close out that particular line item....if so,
This for one day
=COUNTIF(B:B,"<=86400")
This for Two days
=COUNTIF(B:B,"<=172800")-COUNTIF(B:B,"<=86400")
This for Three days
=COUNTIF(B:B,"<=259200")-COUNTIF(B:B,"<=172800")
etc, etc............

hth
Vaya con Dios,
Chuck, CABGx3
 
V

vezerid

Hello,

You will need an auxiliary column next to B:B. In C1:

=COUNTIF($B$1:$B$6,B1)

In further cells you can enter the numbers 1, 2, 3, ... say in cells
F1:F3. Then in G3:

=COUNTIF($C$1:$C$6,F1)/F1

This will show how many numbers are finished in 1, 2, 3 etc days.

HTH
Kostis Vezerides
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top