AverageIF issue

[agtech1]

Hello,

I am having a hard time figuring out this formula, any help is appreciated. I would like get an average of seconds based on certain criteria. For example, if using the table below, how could i get the average of seconds below 1:00?

00:25	1:02	00:26
1:22	00:80	00:30
00:29	00:25	1:01

<tbody>
</tbody>

Thank You

 

[sheetspread]

Is :80 the same as 1:20? Are the cells highlighted in blue below the ones you're trying to average?

Excel 2010
	A	B	C
1	0:25	1:02	0:26
2	1:22	1:20	0:30
3	0:29	0:25	1:01
4
5	27
Sheet8

Cell Formulas
Range	Formula
A5	{=AVERAGE(IF(HOUR($A$1:$C$3)=0,MINUTE($A$1:$C$3)))}
Press CTRL+SHIFT+ENTER to enter array formulas.