How to take hourly average from 15 minutes random data.

I have 15 minutes time interval data but data is not continuous some time he gives 3 values in a hour and some time 2 values in a hour. So this is difficult for me make a code to convert this in a hourly data. I am also attaching time matrix, which is indicate the time for observing the data. Please help me. Thank you in advance.

[Andrei Bobrov]

Sorry my Octave-4.0.3 don't open your file as so him made in MATLAB 5 - very old relise. Please attach your data in .xlsx or .txt file.

[varunesh]

Thanks, Okay, Please see attached file.

Answer 1

[Andrei Bobrov]

d = xlsread('data1.xlsx',1,'A2:B1147');
d0 = datevec(d(:,1) + datenum([1900 1 -1]));
[a,b,c] = unique(d0(:,1:4),'rows','first');
hourly_data = [a, accumarray(c,d(:,2),[],@mean)];

[varunesh]

when I am running last line of this code then i got this error.

Index exceeds matrix dimensions.

did you saw time variable or not??

I mean this

Time

7/6/2016 15:30

7/6/2016 15:45

7/6/2016 16:00

7/6/2016 16:15

7/6/2016 16:30

7/6/2016 16:45

7/6/2016 17:00

7/6/2016 17:15