Power Consumption Over Time Period

[woollyg]

Hi There,

I've been trying how to figure this out but i need a bit of help please!!

I have the below table and am trying to work out the power consumption in 15 minute intervals form 7am to midday. The issue I'm stuck with is adding the total power up during each time period to then be displayed in a graph, any help would be much appreciated. [TABLE="width: 100"]
<tbody>[TR]
[TD]Start Time[/TD]
[TD]End Time[/TD]
[TD]Elapsed Time[/TD]
[TD]Power hwatts[/TD]
[/TR]
[TR]
[TD]10:00[/TD]
[TD]10:03[/TD]
[TD]00:03[/TD]
[TD]7000[/TD]
[/TR]
[TR]
[TD]10:00[/TD]
[TD]10:05[/TD]
[TD]00:05[/TD]
[TD]48[/TD]
[/TR]
[TR]
[TD]07:00[/TD]
[TD]12:00[/TD]
[TD]05:00[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]09:55[/TD]
[TD]10:05[/TD]
[TD]00:10[/TD]
[TD]480[/TD]
[/TR]
[TR]
[TD]07:00[/TD]
[TD]10:00[/TD]
[TD]03:00[/TD]
[TD]72[/TD]
[/TR]
[TR]
[TD]09:00[/TD]
[TD]09:15[/TD]
[TD]00:15[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]07:00[/TD]
[TD]09:00[/TD]
[TD]02:00[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]10:00[/TD]
[TD]12:00[/TD]
[TD]12:00[/TD]
[TD]300[/TD]
[/TR]
</tbody>[/TABLE]

 

[VBA Geek]

Given the data that you have provided, unless I am missing something, I don't see how you could do that.
Look at your third row, Start Time 7 AM, end Time 12 PM, 5 hours have elapsed, 12 hwatts have been used, there is nothing that specifies in which bucket these 12 watts should go, it is possible that they were used from 7 to 8 and then nothing for 4 hours ( which then would raise the question how many were used from 7 to 7:15, how many from 7:16 to 7:30 etc).