|There are probably thousands of lines, although I do use a script to extract only the previous days data.|
Below is some more lines, the data comes from automatic meter reads taken every half hour. If I take one reading from the other that gives me the half hourly consumption. I presently do this using excel, which is abit time consuming.
Each line has a channelID, Date,Time,Value.
The result from the script should give me the following;
Will try the response from nbrane tonight. Thanks