PaulWAdams
New Member
- Joined
- Nov 13, 2019
- Messages
- 2
I need help to get a calculation of run hours per day for 3 units, based on generator breaker shut/open times. We currently use an integration over time to count the time for the breakers closed, but this gets messed up when the computer is rebooted or updated. I need to calculate the decimal run time hours for each of 3 units for each calendar day- with a time that may have started with bkr closed from previous month, until output bkr finally opens within the current month, sometimes several days later. Sometimes we shutdown a unit after midnight, and start it back up in the morning, and so have 2 separate run times within the same day. Our current spreadsheet looks something like this: columns FGHIJK are direct times that generator output bkrs are shut or opened, and BCDE are the daily runtime hours for each unit. The integrated times in B-E can be off by an hour or so on some days due to other activity on the computer- and we need the runtime hours calculated each day. I usually have to manually resolve conflicts by working out the daily hours from the breaker close/open times, but need help breaking it up for the separate days with something close to this table:
<tbody style="border-collapse: collapse; width: auto;">
</tbody>
A | B | C | D | E | F | G | H | I | J | K | |
1 | date | GT1 online | GT2 online | ST3 online | Total Plant online | GT1 bkr shut | GT1 bkr open | GT2 bkr shut | GT2 bkr open | ST3 bkr shut | ST3 bkr open |
2 | 1 | 24 | 15.62 | 24 | 24 | 11/03/19 10:01:00 | 11/03/19 00:48:00 | 11/01/19 06:01:00 | 11/01/19 21:38:00 | 11/05/19 22:41:00 | |
3 | 2 | 24 | 17.98 | 24 | 24 | 11/04/19 07:01:00 | 11/03/19 21:52:00 | 11/02/19 06:01:00 | 11/05/19 22:41:00 | ||
4 | 3 | 15.65 | 24 | 24 | 24 | 11/05/19 22:41:00 | |||||
5 | 4 | 16.98 | 24 | 24 | 24 | ||||||
6 | 5 | 22.68 | 22.68 | 22.68 | 22.68 |
<tbody style="border-collapse: collapse; width: auto;">
</tbody>