I am trying to update hourly usage information for every 1/4 hour. For example Hour 1 has 100 kWh and I need to add it to 4 - 15 minute intervals. The way the math works is from the 100 kWh I add 25 kWh in the first 4 - 15 minute periods (cells) that already have a number of kWhs in them. Then the 2nd hour might have 400 kWh and the next 4 - 15 minute periods (cells).

I have 8760 hours of different data in a column to add to each 4 groups of 15 minute fields/cells which are in a column. So the length of the column is 8760 x 4 = 35,040 fields. I don't want to do this manually of course.

I'd appreciate some kind of formula or macro to solve this.

Regards, Louis59