I need to calculate the average time but exclude zero/blank cells. I am using Excel 2007

0:47:56
0:28:57
0:00:00
0:27:47
0:37:45
0:05:48
0:33:21
0:35:05


Thank you