Average temperature between 2 specific times.

[bangshift440rt]

Hello.
I am making a userform to upload massive amounts of data from a temperature logger.
I have a time column to the left of the temperature column that I inserted with some prior code, starting the time once the temperature exceeds 100F.
I need to find the average temperature ONLY between + fifteen minutes up until 15 minutes prior to the end (end is when temperature does not exceed 100F anymore).

Here is what I have so far, but it seems to be only averaging the two cells assigned to the two variables. How can I make the result (HWAVG1 for example) be the average of the entire range between those two cells? (favg1start and favg1end for example)
Thank you to whoever can help

[mehmetcik]

Please Login or Register  to view this content.

Or even:-

Please Login or Register  to view this content.