Converting 6 minute rainfall and flow data to daily averages

Welcome to the board.

	A	B	C	D	E	F	G
1	Date and Time	Rainfall(mm)	Flow(cumecs)
2	1/1/2015 0:00	0	0.045		1/1/2015	0.0	F2: =SUMIFS(B:B,A:A, ">=" & E2,A:A, "<" & E2 + 1)
3	1/1/2015 0:06	0	0.045		1/2/2015	0.0
4	1/1/2015 0:12	0	0.045		1/3/2015	0.2
5	1/1/2015 0:18	0	0.045		1/4/2015	3.6
6	1/1/2015 0:24	0	0.045		1/5/2015	0.0
7	1/1/2015 0:30	0	0.045		1/6/2015	0.0
8	1/1/2015 0:36	0	0.045		1/7/2015	0.8
9	1/1/2015 0:42	0	0.045		1/8/2015	5.8
10	1/1/2015 0:48	0	0.045		1/9/2015	2.8
11	1/1/2015 0:54	0	0.045		1/10/2015	0.6
12	1/1/2015 1:00	0	0.045		1/11/2015	0.2
13	1/1/2015 1:06	0	0.045		1/12/2015	0.0
14	1/1/2015 1:12	0	0.045		1/13/2015	16.6
15	1/1/2015 1:18	0	0.045		1/14/2015	5.0
16	1/1/2015 1:24	0	0.045		1/15/2015	3.0
17	1/1/2015 1:30	0	0.045		1/16/2015	0.0
18	1/1/2015 1:36	0	0.045		1/17/2015	1.4
19	1/1/2015 1:42	0	0.045		1/18/2015	0.2
20	1/1/2015 1:48	0	0.045		1/19/2015	0.0
21	1/1/2015 1:54	0	0.045		1/20/2015	2.6
22	1/1/2015 2:00	0	0.045		1/21/2015	0.0
23	1/1/2015 2:06	0	0.045		1/22/2015	0.0

A pivot table is another option.

Post the workbook that has problems with the formula.