average formula for time values only

Good Afternoon

I have a sheet with data that gets filled in via a Vlookup, one of the rows returns back results in the time format and I have a calculation cell at the end of the month that provides an Average of all the results.

However there is an option to blank out the data with a variety of options if they are carrying out a task which would affect the daily stats, When they blank out the stats my average formula is not working so I wanted to know if there’s any way I can bypass the fields with text in and purely look at the cells with a time figure in it.

Can you post an example workbook? If you're using the AVERAGE function it should ignore non-numeric values by default.