Need help with max formula!

Max.png



I am currently running a timed experiment where I have a column of increasing times (column A) with a set of values (column C) recorded at those times. The software I am using generates 3-5 data points per second and I have ~50,000 rows I really (REALLY) want to sift through with a formula instead of manually. I would have to scroll through 100 pages to manually select a range

Basically, I want to define a range of times using a upper/lower limit (column A), and obtain the max value of column C within that time range.

________
e.g. at 14:04:59, a drug dose is given to measure a response that has a peak before the next dose is given at 14:15:11. I want to find that peak (i.e. max) value.

So, between the times 14:04:59 and 14:15:11 (represented in column A), I want to find to find the max in column C within that reference range. 14:04:59 would define the lower limit and 14:15:11 would define the upper limit of that range in column A.


Thanks in advance! First time poster here.