Hello,
I have an Excel dilemma. We are trying to track when a “Ticket” hits 60% & 75% of its 9.5 Business hour life, which is based on a workweek. I would like to be able to export my info to excel and have it automatically calculate the 60% & 75% stages. In column “E” we would have something like 8/26/2002 12:08, which is the date & time the ticket was opened. In Column “F” we would have either Pending Customer, Workaround, Reassign, or Open. We need the lines with Pending Customer or Workaround to be highlighted in yellow.
There can be an unlimited # of rows that are exported to excel so each line would have to be able to calculate this info.
I will also need this done for a ticket that has a life of 10 business days.
I do not know enough about Excel to do this on my own. Can anyone come up with a formula to calculate this? Or am I out of luck???
I have an Excel dilemma. We are trying to track when a “Ticket” hits 60% & 75% of its 9.5 Business hour life, which is based on a workweek. I would like to be able to export my info to excel and have it automatically calculate the 60% & 75% stages. In column “E” we would have something like 8/26/2002 12:08, which is the date & time the ticket was opened. In Column “F” we would have either Pending Customer, Workaround, Reassign, or Open. We need the lines with Pending Customer or Workaround to be highlighted in yellow.
There can be an unlimited # of rows that are exported to excel so each line would have to be able to calculate this info.
I will also need this done for a ticket that has a life of 10 business days.
I do not know enough about Excel to do this on my own. Can anyone come up with a formula to calculate this? Or am I out of luck???