DAVERAGE With Calculated Time

[Smokeyham]

I'm trying to use the daverage function, to calculate the average time in a series of data and to only choose the times where the associated code (the"LEFireMedical" Column) is "LE".

Here is a sample:

Excel Workbook
	J	K
1	Response Time	LEFireMedical
2	0:08	Fire
3	0:10	Fire
4	0:10	Fire
5	0:07	LE
6	0:05	LE
7	1:00	FIre
8	0:15	Fire
9	0:30	Fire
10	0:10	LE
11	0:58	FIre
Response Times 2008

I am using the following information for the "Criteria" portion of the formula

Excel Workbook
	D
76	LEFireMedical
77	LE
Response Times 2008

The problem is that I keep on getting a #DIV/0! error message.

I don't know if this is causing my difficulties, but the reponse time is calculated from start time and end time fields.

Here is what the function arguements look like:

=DAVERAGE(J1:K11,"LEFireMedical",D76:D77)

Thanks for any help!

Gordon

 

[Beezkneez]

Your formula
=DAVERAGE(J1:K11,"LEFireMedical",D76:D77)

The red section is the field you want to do an average on. But you have identified column K which isnt a numeric column and the reason for your #DIV/0.
Change that to "Response Time", being the field with the values to be averaged, and it should work.

 

[Smokeyham]

Your formula
=DAVERAGE(J1:K11,"LEFireMedical",D76:D77)

The red section is the field you want to do an average on. But you have identified column K which isnt a numeric column and the reason for your #DIV/0.
Change that to "Response Time", being the field with the values to be averaged, and it should work.

Thanks so much!! This is my first time using the daverage function, and your response helped me to better understand it, and to resolve my problem. Much appreciated!

Gordon