Organize interval data into summed values for chart!

[Prevost]

Hi there. I have a list of electricity use data that I need to use to create a chart. Each row entry contains a calculates an hourly kilowatt hour use extrapolated from an average kilowatt hour use for 15 minutes (so if in the 15 minutes there is 25 kilowatt hours of electricity used then the calculated value would be 100 kilowatt hours).

The problem is that there are data points for every 15 minutes for each day for two years. So I need to get the total use for each day which means I have to sum up all the interval points for each day and then use those summed values to create a usage vs time chart.

Any ideas? The first column contains the date in MM/DD/YYYY format, the second column contains the time (which is in 24 hours and increases by 15 minutes) and the third column contains the kilowatt hour use.

Thanks!

 

[Weazel]

I'd suggest maybe a pivot table with Dates in the rows and kilowatts in the values

 

[Prevost]

Can you explain that a little more please? I think a pivot table would work and hopefully it would automatically sum the kWh values with the same date. Does that sound doable?

 

[Weazel]

sorry, I missed your reply....

I'm not sure if this will work for you but it should give you general idea of what I mean

https://app.box.com/s/0udyu4kuw0knb31ye3ty

 

[Prevost]

Thanks Weazel. I got it to work...I am new to Pivot Tables but after trying some different combinations, I obtained how I wanted the information. I removed the column that contained the time increments and then created a pivot table using the date column and the electricity usage column. It created a table with the dates (incremented by 1 day) and the sum of electricity used for each day...exactly what I needed.
Thanks for your replies!

 

[Weazel]

Great! glad you got it working