Here is the problem:
A is application date
11/01/2005
11/01/2005
11/01/2005
B is process date
11/07/2005
11/09/2005
11/12/2005
My boss built in a formula (I haven't seen it yet) to find the difference
between the dates and then copied that formula into 120 rows of data, but
now he wants a summary sheet showing the average length of time, the minimum
time and the maximum time. Because it is all user-defined, everything we
have tried still calculates all the "zeros" into the average. Solutions? or
do I need to clarify more?
Bookmarks