vba code to get average time by filtering the data

[prabhuduraraj09]

Hi all,

i have below data, i want a code to filter only the task "a" and to know the average time, code should ignore "####" or " ....
i want only to take valid time in consideration .
To get publish the Average time.

Attached example workbook.

S.no Task Total time
1 a 00:15:00
2 a 00:12:00
3 00:32:00
4 a ########
5 a "
6 a 00:19:00
7 00:18:00
8 a 00:24:00
9 a 00:25:00