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?

[TABLE="width: 500"]
<tbody>[TR]
[TD]00:25[/TD]
[TD]1:02[/TD]
[TD]00:26[/TD]
[/TR]
[TR]
[TD]1:22[/TD]
[TD]00:80[/TD]
[TD]00:30[/TD]
[/TR]
[TR]
[TD]00:29[/TD]
[TD]00:25[/TD]
[TD]1:01[/TD]
[/TR]
</tbody>[/TABLE]

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.