Hourly Changes

Hello,

I am looking for some expertise relating to an hourly volumes checker where there are two varibles;

- Hourly check itself
- Periodic Clearing of the volumes

You'd have the hourly totals input manually in to Zone 1, 2, 3 - 10 etc.
Spreadsheet.jpg

The attached picture is a snapshot of the excel file and how the data is inputted.

What I was hoping to do was possibly on a mirrored table, is the cell to factor in the variable of a clearing of the volume, example below shows the volume build from the initial 10:00 to 11:00 then it is cleared down and starts building again at 12:00
Spreadsheet 1.jpg

I was hoping to have it show only the change in volume between the hour, rather then the number we input.

Using the screenshot example provided it would be 10:00 = 414, 11:00 = 11, 12:00 = 23, 13:00 = 7, 14:00 = 5, 15:00 = 81...

I can send the spreadsheet itself to work from if required.

Kind Regards,
Adam

You already have the mechanics worked out. It's a matter of putting in the formulas. Please see the mirror table in columns V:AD.