Calculate values based on time period

Hi All,

I am trying to calculate values in one column based on a time period within a separate column.

The 'time' column and corresponding 'Lq' values are not always in the same columns on each sheet. I started my marco with the find function but am lost after that.

In the following data set I would like to calculate the average Lq value between the time period 14:40 - 15:00

Time Lq
14:35 68.6
14:40 67.8
14:45 70.2
14:50 68.3
14:55 68.5
15:00 69.9

Average 14:40 - 15:00 68.7

Range("A1").Select
    Cells.Find(What:="Time", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
        :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
        False, SearchFormat:=False).Activate