Average time for each individual range count.

[I need excel help]

Hello all,

I am wanting to get the macro I have in this sheet working.
The results I have in col in col G are averaging the times in col AM for each individual race.
I have resulted the first five races.

Col F counts how many there are for each race, col N is each different race. Cols B and D are dates and different tracks, there can be 3 x meetings on any given date.
Time format must remain the same. Otherwise, I cannot use the data if changed. 00:00.0

Thanks.