Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Calls closed in Given periods
Hi,
I'm back again with another problem :-) Hopefully someone can help. I have a list of open dates(A2) and a list of closed dates(B2) which represent problem calls. I need to be able to tell how many were closed in 1 day, 1week, 1 month, 90 days and also what the average time to closure is. Is this something simple to do ? Thanks in advance Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating overlapping time periods | Excel Worksheet Functions | |||
calculating number of three month periods between two dates... | Excel Discussion (Misc queries) | |||
Calculating the maximum value in a range of cells in a closed work | Excel Worksheet Functions | |||
Calculating an Activities During Periods Of Natural Months and/or Dates | Excel Worksheet Functions | |||
Calculating number of periods when payment amount changes | Excel Worksheet Functions |