Hi
On a new spreadsheet, designed to save Patagonia from complete moral breakdown*, I have on Column B from row 11, on all the odd numbered rows, the label "Started". From row 12, on all the even numbered rows, I have the label "Finished". The user will input a start date when a project is started, and an end date when it is finished. When the project is started again he will put a new start date below the last "Finished" entry and so forth.
What I'm struggling with is a few stats formulae.
How would I...
1. Get a formula to look down column C and calculate an average of how long each completed project took to finish. (e.g. C11 has "01 Jan 10" and C12 has "02 Jan 10" (2 days); C13 has "01 Feb 10" and C14 has "04 Feb 10" (4 days); C15 contains "01 Mar 10" and C16 contains "03 Mar 10" 93 days) - so the formula should return an average of 3 days.
2. Get a formula to calculate the average length of time between projects. So using the above example the time between the completion of the first project and the second is 30 days; between the second and third project is 25 days - so the result should be 27.5 days.
Many thanks in advance - Patagonia will be saved*.
As this is a formula question and not a vba question I'm going to cross post on Mr Excel, here: http://www.mrexcel.com/forum/showthr...97#post2248797
Hope you don't mind.
*That part is a lie