Hi

I have this
Formula: copy to clipboard 
=SUBTOTAL(101,Day!BJ20:BJ1992)
formula where I want the average time for only the cells that are shown (meaning filter cells are not taken into account). The problem with this formula is that it takes into account the date as well, I just want an average time within 24 hours.

Example, the cells contains these values:
17/07/2018 12:33:00
17/07/2018 10:04:00
18/07/2018 10:32:00
19/07/2018 12:04:00
19/07/2018 12:36:00
19/07/2018 11:51:00

The formula I have now gives me an average time of 15:36, as it takes into account the date as well. The correct answer should be: 11:36