LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 26
Default Turn around Time

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200707/1

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating TAT (Turn Around Time) Karan Excel Worksheet Functions 2 April 24th 07 11:08 AM
How do I turn SCRL off? Sean Excel Discussion (Misc queries) 1 January 18th 07 10:43 PM
Turn Off New UI Need_More_Screen New Users to Excel 2 June 24th 06 07:20 PM
WHY DOES 1E4 TURN INTO 1.00 E + 04? THANKS Lisa B. Excel Discussion (Misc queries) 1 July 2nd 05 12:48 AM
How do i turn it off ceemo Excel Discussion (Misc queries) 2 May 25th 05 12:25 PM


All times are GMT +1. The time now is 05:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"