Kenneth.Rice

Datalink Power (kW) summation

Discussion created by Kenneth.Rice on Dec 27, 2010
Latest reply on Dec 30, 2010 by hanyong

I need to create an Excel query with Datalink that will take a power tag and for the month take the 1st hour of every day (30 or 31) sum the 30 first hours up and display them in the first cell the the 2nd hour of everyday for the month in the second cell and so on.

 

Is there a fairly ingenious way of doing this versus having to put 1st hour of every day on the spreadsheet and sum with excel?

Outcomes