Help with formula - rolling average

[BPS]

Hi -
I am hoping someone can help me with a formula.

In the spreadsheet below, in column A is the Date and Time (going up in 15 min intervals). Column B is a flow rate at that corresponding Date/Time.

I have added another column (column C) which calculates the rolling hourly average of column B. For each 24hr period I need to return the lowest of the Rolling Average values between the hours 00:00 - 06:00. I have calculated this manually (highlighted yellow) for the purpose of showing what the correct result is.

I need to apply this formula to alot of data (>100,000 rows). Please let me know if I have missed any crucial info!

[TABLE="width: 355"]
<COLGROUP><COL style="WIDTH: 22pt; mso-width-source: userset; mso-width-alt: 1060" width=29><COL style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 4388" width=120><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" width=95><COL style="WIDTH: 101pt; mso-width-source: userset; mso-width-alt: 4937" width=135><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" width=95><TBODY>[TR]
[TD="class: xl77, width: 29, bgcolor: #d9d9d9"]1[/TD]
[TD="class: xl78, width: 120, bgcolor: #d9d9d9"]A[/TD]
[TD="class: xl78, width: 95, bgcolor: #d9d9d9"]B[/TD]
[TD="class: xl78, width: 135, bgcolor: #d9d9d9"]C[/TD]
[TD="class: xl78, width: 95, bgcolor: #d9d9d9"]D[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]2[/TD]
[TD="class: xl65, bgcolor: #bfbfbf"]Date Time[/TD]
[TD="class: xl66, bgcolor: #bfbfbf"]Flow (l/s)[/TD]
[TD="class: xl66, bgcolor: #bfbfbf"]Rolling Average (l/s)[/TD]
[TD="class: xl67, bgcolor: #bfbfbf"]MNF (l/s)[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]3[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 00:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.302[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]4[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 00:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.229[/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]5[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 00:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.037[/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]6[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 00:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.201[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.192[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]7[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 01:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.146[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.153[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]8[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 01:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.339[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.181[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]9[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 01:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.343[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.257[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]10[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 01:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.261[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.272[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]11[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 02:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.174[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.279[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]12[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 02:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.146[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.231[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]13[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 02:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.046[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.157[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]14[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 02:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.005[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.093[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]15[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 03:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.055[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.063[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]16[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 03:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.174[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.070[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]17[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 03:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.018[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.063[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]18[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 03:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.137[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.096[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]19[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 04:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.343[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.168[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]20[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 04:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.348[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.211[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]21[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 04:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.092[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.230[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]22[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 04:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.201[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.246[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]23[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 05:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.220[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.215[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]24[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 05:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.105[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.155[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]25[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 05:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.018[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.136[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]26[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 05:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.037[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.095[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]27[/TD]
[TD="class: xl69, bgcolor: #92d050, align: right"]1/01/2012 06:00[/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: yellow, align: right"]0.053[/TD]
[TD="class: xl73, bgcolor: yellow, align: right"]0.053[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]28[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 06:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.041[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.032[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]29[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 06:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.009[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.029[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]30[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 06:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.041[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.030[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]31[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 07:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.037[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.032[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]32[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 07:15[/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.029[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]33[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 07:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.513[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.197[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]34[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 07:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.055[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.202[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]35[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 08:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.334[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.301[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]36[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 08:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.055[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.239[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]37[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 08:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.224[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.167[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]38[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 08:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.613[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.306[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]39[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 09:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.233[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.281[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]40[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 09:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.069[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.285[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]41[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 09:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.531[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.361[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]42[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 09:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.659[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.373[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]43[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 10:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.778[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.509[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]44[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 10:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]1.012[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.745[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]45[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 10:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.664[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.778[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]46[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 10:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.549[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.751[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]47[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 11:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.861[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.771[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]48[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 11:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.549[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.656[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]49[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 11:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.284[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.561[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]50[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 11:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.783[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.619[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]51[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 12:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]1.259[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.719[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]52[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 12:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]1.154[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.870[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]53[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 12:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]1.117[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]1.078[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]54[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 12:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.600[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]1.032[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]55[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 13:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.842[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.928[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]56[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 13:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.980[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.885[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]57[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 13:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.348[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.693[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]58[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 13:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.568[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.685[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]59[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 14:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.266[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.541[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]60[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 14:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.307[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.372[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]61[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 14:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.430[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.393[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]62[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 14:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.092[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.274[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]63[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 15:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.302[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.283[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]64[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 15:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.247[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.268[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]65[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 15:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.467[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.277[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]66[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 15:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.421[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.359[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]67[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 16:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.586[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.430[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]68[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 16:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.467[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.485[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]69[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 16:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.197[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.418[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]70[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 16:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.472[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.431[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]71[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 17:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.119[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.314[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]72[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 17:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.476[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.316[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]73[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 17:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.055[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.281[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]74[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 17:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.151[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.200[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]75[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 18:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.462[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.286[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]76[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 18:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.046[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.179[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]77[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 18:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.490[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.287[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]78[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 18:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.407[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.351[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]79[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 19:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.394[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.334[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]80[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 19:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.476[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.442[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]81[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 19:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.476[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.438[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]82[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 19:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.348[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.424[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]83[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 20:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.577[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.469[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]84[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 20:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.252[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.413[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]85[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 20:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]1.190[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.592[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]86[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 20:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.618[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.659[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]87[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 21:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.183[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.561[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]88[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 21:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.531[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.631[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]89[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 21:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.490[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.455[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]90[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 21:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.600[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.451[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]91[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 22:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.330[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.488[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]92[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 22:15[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.485[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.476[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]93[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 22:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.206[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.405[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]94[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 22:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.032[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.263[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]95[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 23:00[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.476[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.300[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]96[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 23:15[/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.238[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]97[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 23:30[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.119[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.209[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: #d9d9d9"]98[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]1/01/2012 23:45[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.348[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.314[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
</TBODY>[/TABLE]

 

[btomjack]

Can't you just do =MIN(C3:C27) and fill down?

 

[BPS]

Perhaps I didn't explain it very well. I have many days which I need to calculate the min rolling average for (between 00:00-06:00), so there will be a different min value for each day of the week.

 

[btomjack]

=IF(HOUR(A27)=6,MIN(C3:C27),"")

If all your data is in one column, you can fill down with that formula and you will only see the minimum value from the desired timeframe. The rest will appear as blank cells.

 

[BPS]

Hi - the minimum rolling average value could occur at any time of the day - its not a fixed time range and it could be different every day, in the attached example the lowest value was the average of B23:B26. Even though the lowest could occur at any time of the day I am only concerned with the lowest average between these 00:00 - 06:00.

The formula needs to look at any of the average values between XX/XX/XXXX 00:00 and XX/XX/XXXX 06:00 and return the lowest.

 

[btomjack]

I don't see the problem with my most recent formula. Is it not working? It was designed so that you could use the "fill down" command to copy it to all the cells below it and it will still work.

Here is how it works:
1. The IF() portion of the formula makes it so the desired value only appears next to those cells that represent 6 AM.
2. The MIN(C3:C27) portion pulls the minimum value from a 6-hour time frame. When you fill down, this range of cells will change. So cell D27 has MIN(C3:C27), but cell D28 will have MIN(C4:C28). It always pulls the lowest value in the averages column for the past 6 hours.

This means that it will pull the value you are looking for and put it next to the entry for 06:00 AM. I'm assuming you're saying it's wrong because it doesn't pop up next to the minimum value itself. I don't know how to do that, but this formula will work as a substitute until you can figure out the ideal solution.