how to average time data in a new column

S

Sticky Pete

New Member
Joined
Feb 23, 2016
Messages
3
Hello. I have a large data-set (part of which is shown below) and am trying to take the daily average of each column and export it to another sheet (example shown further below). I would assume VBA is the only way to do this, but I'm rather new to excel coding and am not sure how to go about this particular issue, any advice would be appreciated, thanks.

[TABLE="width: 388"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]10/4/14 12:00 AM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.94[/TD]
[TD="align: right"]2393.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 12:15 AM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.91[/TD]
[TD="align: right"]2411.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 12:30 AM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.85[/TD]
[TD="align: right"]2429.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 12:45 AM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.8[/TD]
[TD="align: right"]2442.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 1:00 AM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.77[/TD]
[TD="align: right"]2450.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 1:15 AM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.71[/TD]
[TD="align: right"]2450.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 1:30 AM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.67[/TD]
[TD="align: right"]2453.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 1:45 AM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.63[/TD]
[TD="align: right"]2449.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 2:00 AM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.61[/TD]
[TD="align: right"]2446.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 2:15 AM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.57[/TD]
[TD="align: right"]2437.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 2:30 AM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.54[/TD]
[TD="align: right"]2424.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 2:45 AM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.5[/TD]
[TD="align: right"]2405.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 3:00 AM[/TD]
[TD="align: right"]0.03[/TD]
[TD="align: right"]15.8[/TD]
[TD="align: right"]2446.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 3:15 AM[/TD]
[TD="align: right"]0.03[/TD]
[TD="align: right"]16.11[/TD]
[TD="align: right"]2078.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 3:30 AM[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]16.24[/TD]
[TD="align: right"]1778.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 3:45 AM[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]16.27[/TD]
[TD="align: right"]1800.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 4:00 AM[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]16.27[/TD]
[TD="align: right"]1977.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 4:15 AM[/TD]
[TD="align: right"]0.05[/TD]
[TD="align: right"]16.51[/TD]
[TD="align: right"]2020.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 4:30 AM[/TD]
[TD="align: right"]0.07[/TD]
[TD="align: right"]17.25[/TD]
[TD="align: right"]1307.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 4:45 AM[/TD]
[TD="align: right"]0.08[/TD]
[TD="align: right"]17.12[/TD]
[TD="align: right"]715.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 5:00 AM[/TD]
[TD="align: right"]0.07[/TD]
[TD="align: right"]16.98[/TD]
[TD="align: right"]491.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 5:15 AM[/TD]
[TD="align: right"]0.06[/TD]
[TD="align: right"]16.89[/TD]
[TD="align: right"]412.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 5:30 AM[/TD]
[TD="align: right"]0.05[/TD]
[TD="align: right"]16.85[/TD]
[TD="align: right"]430.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 5:45 AM[/TD]
[TD="align: right"]0.03[/TD]
[TD="align: right"]16.82[/TD]
[TD="align: right"]481.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 6:00 AM[/TD]
[TD="align: right"]0.03[/TD]
[TD="align: right"]16.77[/TD]
[TD="align: right"]525.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 6:15 AM[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]16.7[/TD]
[TD="align: right"]578.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 6:30 AM[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]16.66[/TD]
[TD="align: right"]651.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 6:45 AM[/TD]
[TD="align: right"]0.03[/TD]
[TD="align: right"]16.68[/TD]
[TD="align: right"]696.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 7:00 AM[/TD]
[TD="align: right"]0.03[/TD]
[TD="align: right"]16.72[/TD]
[TD="align: right"]651.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 7:15 AM[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]16.72[/TD]
[TD="align: right"]681.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 7:30 AM[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]16.98[/TD]
[TD="align: right"]495.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 7:45 AM[/TD]
[TD="align: right"]0.09[/TD]
[TD="align: right"]16.85[/TD]
[TD="align: right"]359.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 8:00 AM[/TD]
[TD="align: right"]0.07[/TD]
[TD="align: right"]16.8[/TD]
[TD="align: right"]374.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 8:15 AM[/TD]
[TD="align: right"]0.05[/TD]
[TD="align: right"]16.81[/TD]
[TD="align: right"]401.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 8:30 AM[/TD]
[TD="align: right"]0.08[/TD]
[TD="align: right"]16.81[/TD]
[TD="align: right"]426.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 8:45 AM[/TD]
[TD="align: right"]0.12[/TD]
[TD="align: right"]16.52[/TD]
[TD="align: right"]238.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 9:00 AM[/TD]
[TD="align: right"]0.09[/TD]
[TD="align: right"]16.54[/TD]
[TD="align: right"]275.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 9:15 AM[/TD]
[TD="align: right"]0.07[/TD]
[TD="align: right"]16.64[/TD]
[TD="align: right"]311.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 9:30 AM[/TD]
[TD="align: right"]0.06[/TD]
[TD="align: right"]16.69[/TD]
[TD="align: right"]370.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 9:45 AM[/TD]
[TD="align: right"]0.05[/TD]
[TD="align: right"]16.75[/TD]
[TD="align: right"]443.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 10:00 AM[/TD]
[TD="align: right"]0.04[/TD]
[TD="align: right"]16.79[/TD]
[TD="align: right"]520.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 10:15 AM[/TD]
[TD="align: right"]0.03[/TD]
[TD="align: right"]16.77[/TD]
[TD="align: right"]594.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 10:30 AM[/TD]
[TD="align: right"]0.03[/TD]
[TD="align: right"]16.79[/TD]
[TD="align: right"]676.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 10:45 AM[/TD]
[TD="align: right"]0.03[/TD]
[TD="align: right"]16.76[/TD]
[TD="align: right"]760.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 11:00 AM[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]16.75[/TD]
[TD="align: right"]849.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 11:15 AM[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]16.76[/TD]
[TD="align: right"]929.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 11:30 AM[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]16.84[/TD]
[TD="align: right"]1002.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 11:45 AM[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]16.77[/TD]
[TD="align: right"]1077.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 12:00 PM[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]16.69[/TD]
[TD="align: right"]1154.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 12:15 PM[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]16.64[/TD]
[TD="align: right"]1228.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 12:30 PM[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]16.65[/TD]
[TD="align: right"]1304.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 12:45 PM[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]16.72[/TD]
[TD="align: right"]1371.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 1:00 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.8[/TD]
[TD="align: right"]1437.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 1:15 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.69[/TD]
[TD="align: right"]1497.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 1:30 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.55[/TD]
[TD="align: right"]1543.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 1:45 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.47[/TD]
[TD="align: right"]1591.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 2:00 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.49[/TD]
[TD="align: right"]1638.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 2:15 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.41[/TD]
[TD="align: right"]1676.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 2:30 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.37[/TD]
[TD="align: right"]1718.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 2:45 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.46[/TD]
[TD="align: right"]1759.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 3:00 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.48[/TD]
[TD="align: right"]1795.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 3:15 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.48[/TD]
[TD="align: right"]1832.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 3:30 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.4[/TD]
[TD="align: right"]1867.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 3:45 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.29[/TD]
[TD="align: right"]1894.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 4:00 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.28[/TD]
[TD="align: right"]1919.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 4:15 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.26[/TD]
[TD="align: right"]1935.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 4:30 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.28[/TD]
[TD="align: right"]1951.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 4:45 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.16[/TD]
[TD="align: right"]1970.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 5:00 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.12[/TD]
[TD="align: right"]1986.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 5:15 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.1[/TD]
[TD="align: right"]2000.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 5:30 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.09[/TD]
[TD="align: right"]2013.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 5:45 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]16.05[/TD]
[TD="align: right"]2020.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 6:00 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.98[/TD]
[TD="align: right"]2032.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 6:15 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.9[/TD]
[TD="align: right"]2044.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 6:30 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.8[/TD]
[TD="align: right"]2053.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 6:45 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.68[/TD]
[TD="align: right"]2066.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 7:00 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.54[/TD]
[TD="align: right"]2076.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 7:15 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.35[/TD]
[TD="align: right"]2089.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 7:30 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.15[/TD]
[TD="align: right"]2096.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 7:45 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]15.01[/TD]
[TD="align: right"]2104.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 8:00 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]14.88[/TD]
[TD="align: right"]2112.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 8:15 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]14.76[/TD]
[TD="align: right"]2125.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 8:30 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]14.66[/TD]
[TD="align: right"]2131.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 8:45 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]14.59[/TD]
[TD="align: right"]2136.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 9:00 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]14.5[/TD]
[TD="align: right"]2139.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 9:15 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]14.45[/TD]
[TD="align: right"]2147.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 9:30 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]14.4[/TD]
[TD="align: right"]2156.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 9:45 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]14.31[/TD]
[TD="align: right"]2163.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 10:00 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]14.19[/TD]
[TD="align: right"]2170.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 10:15 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]14.04[/TD]
[TD="align: right"]2176.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 10:30 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]13.86[/TD]
[TD="align: right"]2181.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 10:45 PM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]13.78[/TD]
[TD="align: right"]2187.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 11:00 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.69[/TD]
[TD="align: right"]2190.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 11:15 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.6[/TD]
[TD="align: right"]2195.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 11:30 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.48[/TD]
[TD="align: right"]2200.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/4/14 11:45 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.38[/TD]
[TD="align: right"]2204.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 12:00 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.34[/TD]
[TD="align: right"]2207.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 12:15 AM[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]13.27[/TD]
[TD="align: right"]2216.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 12:30 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.19[/TD]
[TD="align: right"]2224.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 12:45 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.12[/TD]
[TD="align: right"]2233.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 1:00 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.08[/TD]
[TD="align: right"]2241.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 1:15 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.02[/TD]
[TD="align: right"]2247.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 1:30 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.96[/TD]
[TD="align: right"]2252.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 1:45 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.88[/TD]
[TD="align: right"]2258.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 2:00 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.8[/TD]
[TD="align: right"]2261.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 2:15 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.71[/TD]
[TD="align: right"]2265.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 2:30 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.62[/TD]
[TD="align: right"]2266.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 2:45 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.53[/TD]
[TD="align: right"]2264.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 3:00 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.48[/TD]
[TD="align: right"]2262.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 3:15 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.42[/TD]
[TD="align: right"]2262.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 3:30 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.32[/TD]
[TD="align: right"]2265.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 3:45 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.27[/TD]
[TD="align: right"]2266.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 4:00 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.17[/TD]
[TD="align: right"]2269.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 4:15 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.12[/TD]
[TD="align: right"]2273.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 4:30 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.09[/TD]
[TD="align: right"]2274.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 4:45 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.03[/TD]
[TD="align: right"]2280.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 5:00 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.96[/TD]
[TD="align: right"]2283.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 5:15 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.87[/TD]
[TD="align: right"]2280.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 5:30 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.79[/TD]
[TD="align: right"]2275.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 5:45 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.71[/TD]
[TD="align: right"]2273.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 6:00 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.62[/TD]
[TD="align: right"]2275.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 6:15 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.54[/TD]
[TD="align: right"]2283.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 6:30 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.55[/TD]
[TD="align: right"]2283.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 6:45 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.51[/TD]
[TD="align: right"]2290.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 7:00 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.47[/TD]
[TD="align: right"]2293.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 7:15 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.46[/TD]
[TD="align: right"]2296.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 7:30 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.46[/TD]
[TD="align: right"]2294.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 7:45 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.47[/TD]
[TD="align: right"]2295.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 8:00 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.49[/TD]
[TD="align: right"]2294.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 8:15 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.5[/TD]
[TD="align: right"]2292.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 8:30 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.55[/TD]
[TD="align: right"]2289.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 8:45 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.58[/TD]
[TD="align: right"]2292.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 9:00 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.64[/TD]
[TD="align: right"]2291.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 9:15 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.72[/TD]
[TD="align: right"]2291.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 9:30 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.77[/TD]
[TD="align: right"]2293.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 9:45 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.82[/TD]
[TD="align: right"]2295.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 10:00 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.92[/TD]
[TD="align: right"]2300.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 10:15 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.05[/TD]
[TD="align: right"]2305.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 10:30 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.17[/TD]
[TD="align: right"]2313.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 10:45 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.27[/TD]
[TD="align: right"]2326.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 11:00 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.54[/TD]
[TD="align: right"]2335.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 11:15 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.63[/TD]
[TD="align: right"]2338.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 11:30 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.81[/TD]
[TD="align: right"]2342.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 11:45 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.06[/TD]
[TD="align: right"]2339.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 12:00 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.31[/TD]
[TD="align: right"]2334.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 12:15 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.31[/TD]
[TD="align: right"]2329.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 12:30 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.43[/TD]
[TD="align: right"]2324.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 12:45 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.54[/TD]
[TD="align: right"]2324.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 1:00 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.62[/TD]
[TD="align: right"]2324.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 1:15 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.82[/TD]
[TD="align: right"]2322.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 1:30 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.95[/TD]
[TD="align: right"]2317.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 1:45 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.97[/TD]
[TD="align: right"]2315.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 2:00 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.92[/TD]
[TD="align: right"]2311.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 2:15 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.93[/TD]
[TD="align: right"]2310.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 2:30 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]14.01[/TD]
[TD="align: right"]2309.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 2:45 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]14.13[/TD]
[TD="align: right"]2304.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 3:00 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]14.14[/TD]
[TD="align: right"]2302.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 3:15 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]14.16[/TD]
[TD="align: right"]2299.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 3:30 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]14.22[/TD]
[TD="align: right"]2300.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 3:45 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]14.2[/TD]
[TD="align: right"]2296.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 4:00 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]14.16[/TD]
[TD="align: right"]2299.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 4:15 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]14.02[/TD]
[TD="align: right"]2297.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 4:30 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.8[/TD]
[TD="align: right"]2300.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 4:45 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.67[/TD]
[TD="align: right"]2304.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 5:00 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.57[/TD]
[TD="align: right"]2307.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 5:15 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.53[/TD]
[TD="align: right"]2310.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 5:30 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.52[/TD]
[TD="align: right"]2314.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 5:45 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.46[/TD]
[TD="align: right"]2315.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 6:00 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.4[/TD]
[TD="align: right"]2321.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 6:15 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.33[/TD]
[TD="align: right"]2323.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 6:30 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.29[/TD]
[TD="align: right"]2326.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 6:45 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.18[/TD]
[TD="align: right"]2328.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 7:00 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.07[/TD]
[TD="align: right"]2329.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 7:15 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.04[/TD]
[TD="align: right"]2332.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 7:30 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.04[/TD]
[TD="align: right"]2335.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 7:45 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]13.02[/TD]
[TD="align: right"]2337.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 8:00 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.93[/TD]
[TD="align: right"]2336.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 8:15 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.83[/TD]
[TD="align: right"]2338.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 8:30 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.73[/TD]
[TD="align: right"]2337.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 8:45 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.6[/TD]
[TD="align: right"]2342.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 9:00 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.51[/TD]
[TD="align: right"]2345.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 9:15 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.38[/TD]
[TD="align: right"]2348.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 9:30 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.29[/TD]
[TD="align: right"]2354.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 9:45 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.22[/TD]
[TD="align: right"]2361.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 10:00 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.17[/TD]
[TD="align: right"]2364.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 10:15 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.11[/TD]
[TD="align: right"]2370.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 10:30 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.1[/TD]
[TD="align: right"]2364.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 10:45 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.04[/TD]
[TD="align: right"]2362.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 11:00 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]12.02[/TD]
[TD="align: right"]2369.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 11:15 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.99[/TD]
[TD="align: right"]2374.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 11:30 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.95[/TD]
[TD="align: right"]2373.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/14 11:45 PM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.92[/TD]
[TD="align: right"]2373.0[/TD]
[/TR]
[TR]
[TD="align: right"]10/6/14 12:00 AM[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]11.9[/TD]
[TD="align: right"]2372.0[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 478"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]10/4/2014[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: right"]15.98322918[/TD]
[TD="align: right"]1575.78125[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/2014[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: right"]12.69687507[/TD]
[TD="align: right"]2304.65625[/TD]
[/TR]
[TR]
[TD="align: right"]10/6/2014[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: right"]12.939375[/TD]
[TD="align: right"]2342.354167[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Sort by date Sort by votes
Or if you prefer a formula approach with target dates in F1:F3 and this formula in say G1:I3
Code: 
=AVERAGEIFS(B$1:B$193,$A$1:$A$193,">="&$F1,$A$1:$A$193,"<"&($F1+1))

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]
F​
[/td][td]
G​
[/td][td]
H​
[/td][td]
I​
[/td][/tr]
[tr][td]
1​
[/td][td]
10/4/2014​
[/td][td]
0.023646​
[/td][td]
15.98323​
[/td][td]
1575.781​
[/td][/tr]

[tr][td]
2​
[/td][td]
10/5/2014​
[/td][td]
0.000104​
[/td][td]
12.69688​
[/td][td]
2304.656​
[/td][/tr]

[tr][td]
3​
[/td][td]
10/6/2014​
[/td][td]
0​
[/td][td]
11.9​
[/td][td]
2372​
[/td][/tr]
[/table]
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
Finding Numbers from a Column Using Target Numbers
2
Replies
11
Views
414
Cubist
Cubist
T
  • Solved
Scaling a Data Set
Replies
6
Views
261
felixstraube
F
JenniferMurphy
  • Question Question
I could use help with a bit of a complex table addressing problem
Replies
1
Views
177
JenniferMurphy
JenniferMurphy
JenniferMurphy
  • Solved
How to rank a combination of 2 or more columns?
2
Replies
10
Views
273
Scott Huish
Scott Huish
R
  • Solved
vlookup, INDEX, or SUMPRODUCT???
2
Replies
10
Views
820
KRice
K

Forum statistics

Threads
1,222,900
Messages
6,168,926
Members
452,227
Latest member
sam1121

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top