Ravi Sir's Cards › Excel
Complaint Ticket Management System in Excel (card 1 of 2)
Revision card 1 for Complaint Ticket Management System in Excel: Hours taken: =IF(H5="","",ROUND((H5-B5)*24,1)) gives 8.0; Ticket number: ="TK-"&TEXT(ROW()-4,"000") gives TK-001; Tickets per agent: =COUNTIFS(Tickets!$F$5:$F$3000,A5) gives 6. Includes an example data table.
Read card text
What this card says
1 for Complaint Ticket Management System in Excel: Hours taken: =IF(H5="","",ROUND((H5-B5)*24,1)) gives 8.0
Ticket number: ="TK-"&TEXT(ROW()-4,"000") gives TK-001
Tickets per agent: =COUNTIFS(Tickets!$F$5:$F$3000,A5) gives 6. Includes an
Example
data table
Learn this in the lesson: Complaint Ticket Management System in Excel: Priorities, Due-by Time, Hours Taken, Met or Breached and Agent Report