Hi,

I need your help to convert 15min data to hourly. My data looks like this: Date and time in column A and the data in column B

21 01 2015 18:15 1.29
21 01 2015 18:20 1.29
21 01 2015 18:25 1.28
21 01 2015 18:30 1.29
21 01 2015 18:35 1.30
21 01 2015 18:40 1.31
21 01 2015 18:45 1.30
21 01 2015 18:50 1.32
21 01 2015 18:55 1.33
21 01 2015 19:00 1.33
21 01 2015 19:05 1.34
21 01 2015 19:10 1.35
21 01 2015 19:15 1.35
21 01 2015 19:20 1.36
21 01 2015 19:25 1.36
21 01 2015 19:30 1.37
21 01 2015 19:35 1.38
21 01 2015 19:40 1.38
21 01 2015 19:45 1.39

Thanks
Roni