Hello! I've got a problem with some cumulative printer data. The data is broken out by Machine (printer), Recipe (what's being printed), Time, Pages Printed, Uptime (how long the printer has been working), and Downtime (how long the printer has not been working).
The twist: all of the recorded data is cumulative per Machine and Recipe - see below. Each machine prints one page per minute, so the "Pages Printed" count starts at 1, then 2, etc. The rightmost three columns are all cumulative. You can see machine 1 turn off at 9:04 below, then back on at 9:09 with a new recipe.
| Machine | Recipe | Time | Pages Printed | Uptime (seconds) | Downtime (seconds) |
| 1 | 5 | 8/23/2023 9:00 | 1 | 0 | 0 |
| 1 | 5 | 8/23/2023 9:01 | 2 | 60 | 0 |
| 1 | 5 | 8/23/2023 9:02 | 3 | 120 | 0 |
| 1 | 5 | 8/23/2023 9:03 | 4 | 180 | 0 |
| 1 | 5 | 8/23/2023 9:04 | 4 | 180 | 60 |
| 1 | 5 | 8/23/2023 9:05 | 4 | 180 | 120 |
| 1 | 5 | 8/23/2023 9:06 | 4 | 180 | 180 |
| 1 | 5 | 8/23/2023 9:07 | 4 | 180 | 240 |
| 1 | 5 | 8/23/2023 9:08 | 4 | 180 | 320 |
| 1 | 4 | 8/23/2023 9:09 | 0 | 0 | 0 |
| 1 | 4 | 8/23/2023 9:10 | 1 | 60 | 0 |
| 1 | 4 | 8/23/2023 9:11 | 2 | 120 | 0 |
| 1 | 4 | 8/23/2023 9:12 | 3 | 180 | 0 |
| 2 | 5 | 8/23/2023 9:00 | 1 | 0 | 0 |
| 2 | 5 | 8/23/2023 9:01 | 2 | 60 | 0 |
| 2 | 5 | 8/23/2023 9:02 | 3 | 120 | 0 |
| 2 | 5 | 8/23/2023 9:03 | 4 | 180 | 0 |
| 3 | 5 | 8/23/2023 9:00 | 1 | 0 | 0 |
| 3 | 5 | 8/23/2023 9:01 | 2 | 60 | 0 |
| 3 | 5 | 8/23/2023 9:02 | 3 | 120 | 0 |
| 3 | 5 | 8/23/2023 9:03 | 4 | 180 | 0 |
The issue: with multiple machines and recipes being used, how do I calculate the pages printed by each machine, not to mention the uptime/downtime for each machine?
Right now, I'm doing a simple MAX() - MIN() for each, but that is often wrong. Notice the change in Recipe at 9:09 for machine 1, that "zeros" out the Pages Printed and other metrics, which will then cause errors in a simple MAX - MIN formula.
