I have a workbook that has 2 worksheets. The first is YTDTotal and on that worksheet, I track system outages. These outages are tracked by Affected CI (which is column C) and column D gives me the total Impacted Business Hours Duration in hours (which is calculated by subtracting column E from F). The second worksheet lists my targets for total outage time in minutes (column L) by category. I need to add a column into the YTD-Total worksheet that will keep a RUNNING TOTAL of how much time is left before we go over our total outage time target per affected CI (each category). There are some affected CI's that don't have target times, so those don't need a running a total - what I currently have is sufficient. I believe I need to subtract column D (Impacted Business Hours Duration) from the YTD-Total worksheet from column L (Total min) in the Uptime Targets worksheet, but I'm not sure how to convert the time difference (one calculating in minutes and the other in hours) and how to keep each affected CI category together between worksheets. Outages are entered by date, so I might have one Affected CI entered that is not in a group with the same category, but I still need it to keep the running total.
I'll attach the worksheet. Any help would be GREATLY appreciated.
I'll attach the worksheet. Any help would be GREATLY appreciated.