This article outlines how to convert 5 minute data from the detailed site data CSV file into the desired time interval.
In the column F, create new time-stamps with the desired time interval. To do this, select the cell F1 and name appropriately. For this example we will name it "New Time-Stamp".
In cell G1, set the desired time interval.
With the cell selected scroll down to the end of the table. Select the whole F column by pressing 'Left Shift' + the las cell in the 'New Time Stamp' column. Press Ctrl+D to fill the whole column with the formula.
Select the whole table and then click 'Subtotal' under the Data section.
This will give you the Energy Generated and the Energy consumed at the desired time interval.
If you want to display only the subtotals click on the little '3' button on the left hand-side - this will hide all the unnecessary intermediate rows.