Spreadsheet: 544830d1509045585-conditional-formatting-based-on-date-and-time-queue-template
Sheet: 081715

 | Belk | Total | Oldest |  | 6+ Days
 | Escalation | 1 | 2015-08-10 00:00:00 |  | 5 Days
 | Customer Service | 76 | 7.27.15 |  | 4 Days
 | [NAME] | 108 | 7.30.15 |  | 3 Days
 | Accommodations | 110 | 7.31.15 |  | 0-2 Days
 | [NAME] | 18 | 8.10.15
 | Call Backs | 0
 | Sr Sup Callback | Total | Open | WIP | WFR | WFCR | WFVR | Updated | Declined | Oldest | Oldest Open
 | ACE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | GNC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PBS AV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PBS HV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Dollar General | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RadioShack | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Mattel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | iRobot | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Escalation Queues | Total | Open | WIP | WFR | WFCR | WFVR | Updated | Declined | Oldest | Oldest Open
 | ACE | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2015-08-13 00:00:00 | 2015-08-13 00:00:00
 | GNC | 5 | 0 | 3 | 0 | 0 | 0 | 2 | 0 | 2015-08-11 00:00:00
 | PBS AV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PBS HV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Dollar General | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 2015-08-11 00:00:00 | 2015-08-14 00:00:00
 | RadioShack | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2015-07-23 00:00:00 | 2015-07-23 00:00:00
 | Mattel | 3 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 2015-06-25 00:00:00
 | iRobot | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Customer Service | Total | Open | WIP | WFR | WFCR | WFVR | Updated | Declined | Oldest | Oldest Open
 | ACE Issues | 192 | 58 | 1 | 0 | 0 | 132 | 0 | 1 | 2015-06-24 00:00:00 | 2015-08-07 00:00:00
 | GNC | 24 | 14 | 3 | 1 | 4 | 1 | 0 | 1 | 2015-07-27 00:00:00 | 2015-08-15 00:00:00
 | PBS AV | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2015-08-05 00:00:00 | 2015-08-05 00:00:00
 | PBS HV | 32 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 2015-07-06 00:00:00 | 2015-07-30 00:00:00
 | Dollar General | 5 | 1 | 1 | 3 | 0 | 0 | 0 | 0 | 2015-08-12 00:00:00 | 2015-08-17 00:00:00
 | RadioShack | 6 | 5 | 1 | 0 | 0 | 0 | 0 | 0 | 2015-07-23 00:00:00 | 2015-07-23 00:00:00
 | Mattel | 34 | 21 | 6 | 4 | 0 | 0 | 3 | 0 | 2015-06-29 00:00:00 | 2015-07-15 00:00:00
 | iRobot | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  | 2015-08-14 00:00:00
 | Reship | Total | Open | WIP | WFR | WFCR | WFVR | Updated | Declined | Oldest | Oldest Open
 | GNC | 54 | 42 | 10 | 1 | 1 | 0 | 0 | 0 | 2015-08-11 00:00:00 | 2015-08-15 00:00:00
 | PBS AV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PBS HV | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2015-08-13 00:00:00
 | Dollar General | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Mattel | 6 | 1 | 0 | 0 | 4 | 0 | 1 | 0 | 2015-06-14 00:00:00 | 2015-08-16 00:00:00
 | iRobot | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2015-08-17 00:00:00 | 2015-08-17 00:00:00
 | Pickup | Total | Open | WIP | WFR | WFCR | WFVR | Updated | Declined | Oldest | Oldest Open
 | ACE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | GNC | 11 | 10 | 1 | 0 | 0 | 0 | 0 | 0 | 2015-08-08 00:00:00 | 2015-08-08 00:00:00
 | PBS AV | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2015-08-13 00:00:00 | 2015-08-13 00:00:00
 | PBS HV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Dollar General | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RadioShack | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Mattel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | iRobot | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Canadian Returns | Total | Open | WIP | WFR | WFCR | WFVR | Updated | Declined | Oldest | Oldest Open
 | PBS HV | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2015-08-11 00:00:00 | 2015-08-11 00:00:00
 | Mattel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | iRobot | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Other | Total | Open | WIP | WFR | WFCR | WFVR | Updated | Declined | Oldest | Oldest Open
 | GNC Claims | 5 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 2015-08-11 00:00:00 | 2015-08-15 00:00:00
 | PBS Statement Request | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0