All,
I'm struggling with the following. I have a table that includes a list of help desk tickets for a number of systems that have Date Recorded and Date Resolved dates. Each help desk ticket also includes a column for total days the ticket was open (e.g., Date Resolved - Date Recorded). Some tickets are "open" and do not have resolved dates - in which case the total downtime for that ticket would be today - date recorded. The tickets are also categorized as "down", "degraded", or "up". I'd only like to calculate the "down" ticket days.
I'm wanting to count the total NET down days for the systems and sub-areas included for "down" tickeets. For example, if for system X section 1, ticket 1 was opened 5/10/18 and closed on 5/12/18, and ticket two was opened 5/10/18 and was closed on 5/15/18, the total net days for system X section 1 would be 6 days (e.g., 5/10/18 to 5/15/18) and not 9 days (e.g., 5/10/18-5/12/18 [3 days] + 5/10/18-5/15/18 [6]).
I was wondering if there was any way to accomplish this in a button-activated macro. I've attached an example workbook to provide additional clarity.
Best,
Chris
Bookmarks