Thank you!

Is there a way to figure this out?

Time Minute Difference

2013-03-02 15:00:00 10

2013-03-02 16:20:00 80

2013-03-02 17:20:00 60

But since it has to be hour ending, I would essentially need something like this (add another record for each hour):

Time Minute Difference

2013-03-02 15:00:00 10

*2013-03-02 16:00:00 *60

2013-03-02 16:20:00 *20

*2013-03-02 17:00:00 *40

2013-03-02 17:20:00 *20

The added records are 2013-03-02 16:00:00 and 2013-03-02 17:00:00 and updated the minute difference... One of the requirements is that there has to be a weighted average value for each hour, every hour even if there isn't an actual record.

Is there a way to insert missing hour ending records with the previous value?

I thought I was done with this until he mentioned that...

Thank you!