how to average time data in a new column

[Sticky Pete]

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.

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

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

10/4/2014	#DIV/0!	15.98322918	1575.78125
10/5/2014	#DIV/0!	12.69687507	2304.65625
10/6/2014	#DIV/0!	12.939375	2342.354167

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[PaddyD]

Hi - no need for anything fancy - you can do it all with a pivot table. Have you used them before? Some general info here:

http://www.contextures.com/pivottableindex.html

...post back if you can't get it sorted.

 

[FlameRetired]

Or if you prefer a formula approach with target dates in F1:F3 and this formula in say G1:I3

=AVERAGEIFS(B$1:B$193,$A$1:$A$193,">="&$F1,$A$1:$A$193,"<"&($F1+1))

Row\Col	F​	G​	H​	I​
1​	10/4/2014​	0.023646​	15.98323​	1575.781​
2​	10/5/2014​	0.000104​	12.69688​	2304.656​
3​	10/6/2014​	0​	11.9​	2372​

 

[Sticky Pete]

awesome, yup that worked perfectly. Thanks!!!!!