Average of Date

[Donna]

I need to take this data, find out how long it took to work on a project by Name and then average it. Any suggestions?

PROJECT DATE Name last worked
5/17/2004 Carleen #N/A
5/17/2004 Lorri #N/A
5/15/2004 Lorri #N/A
5/15/2004 Debbie G 6/29/04
5/15/2004 Janice #N/A
4/30/2002 Dave 6/22/04
5/22/2002 Lorri 6/28/04
5/26/2002 Janice 6/21/04
7/13/2002 Lorri #N/A
9/3/2002 Debbie G #N/A
10/15/2002 Debbie G 6/29/04

 

[Frank Kabel]

Hi
and how do you calculate the time worked for the project if you have
#NA as value?

--
Regards
Frank Kabel
Frankfurt, Germany

I need to take this data, find out how long it took to work on a

project by Name and then average it. Any suggestions?

 

[Debra Dalgleish]

It's not clear what the #N/A errors mean, but you could add a column to
the table, and calculate the duration, by subtracting Project Date from
Last Worked. You could treat the #N/As as zeros. e.g.:
=IF(ISNUMBER(C2),C2-A2,0)

To summarize the data, build a pivot table from the table, and use
Average of Duration in the data area.

There are instructions and links for pivot tables on Jon Peltier's site:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

 

[Donna]

That is exactly what I have been doing-treating them like zeros. I will try your formula-

Thanks

 

[Donna]

I have been changing them to a zero.
--
Donna

Hi
and how do you calculate the time worked for the project if you have
#NA as value?

--
Regards
Frank Kabel
Frankfurt, Germany


project by Name and then average it. Any suggestions?