Hi I need help in my worksheet attached...

In the first Tab (Ticket List), I need help in the SLA Failed Column.
It should work like this..

If priority 1, SLA should be within 30 min
If priority 2, SLA should be within 24 hours
If priority 3, SLA should be within 48 hours

It would say Yes with a Red highlight in the SLA Failed Column if it exceeds the following stated above according to priority

------------------------------

I also need help in generating a report, in the second tab (Report Transaction), user can type in the start date and end date.

Showing a breakdown based on the first sheet are the Number of Tickets
> Open
> Closed
> Total Update & Open tickets (*uninclude those that have been closed already, let's say A has an update status then A also has a closed status on the next row, Ticket A won't add a count in the total number for this part)
>SLA Failed Tickets

NOTE: SLA Failed Tickets are based on update and closed status
Will it be possible to show the breakdown of updated and closed tickets under SLA Failed Tickets?

Also a graph showing it if possible once clicked on generate report...

Please help... Thank you so much...