Change a half hourly table to hourly time table

I have a table which consists of 220 columns of half-hourly values over the course of a year. Is there a way to change the table to hourly values which are the average across two of the half hourly values.

Answer 1

[Walter Roberson]

The easiest way is to use a timetable object and the retime() function.

[Fraser McMurray]

Thanks for the help. However, when I try this I get an error:

Undefined function 'retime' for input arguments of type 'table'

Do I need to change the format of the table to something different? If so what is the best way to approach this?

[Peter Perkins]

Assuming you have R2016b or later, use table2timetable to create a timetable first, then call retime, using 'hourly'.

Pre-R2016b, you can create a new variable in your table that is your timestamps rounded down to the previous hour (use dateshift), then use varfun and group by that new variable to compute the mean of all the data variables.

[Steven Lord]

The retime function is defined for timetable arrays. It is not defined for table arrays. A timetable is required to contain some date and/or time information by the way it is constructed, while a table is not.