Summation for every hour from a timetable

This is a part of the timetable I'am working with.

I want to know for every hour the sum of the values, for that hour, which are located in colum 3.

So for the first hour ( Date(1:6) ) I want to know the Energy_kwh sommation from 1 to 6 (Sum(Energy_kwh(1:6))

for the second hour ( Date(7:12) ) I want to know the Energy_kwh sommation from 7 to 12 (Sum(Energy_kwh(7:12))

....

The time stamps are not equal, this make it difficult.

Who has an idea for this problem?

Answer 1

[Steven Lord]

retime your timetable, either using the "Retime Timetable" Live Editor Task (see the Aggregate Data section of the example, you'd need to change the time step and the general rule) or the retime function (adapt the Aggregate Timetable Data and Calculate Mean Values example.)

[Dora de Jong]

Thank you!

I used the following:

TT2 = retime(Tilted_sailing.solar,'hourly','sum');

And it works perfectly.