Spreadsheet: 73812d1274378312-excel-2007-if-then-statement-meeting-multiple-criteria-posting-sla
Sheet: January Detail

 |  |  |  |  |  |  | Days to Exclude | Day Start | Day End
 |  |  |  |  |  |  | 2010-01-01 00:00:00 | 08:00:00 | 17:00:00
 |  |  |  |  |  |  | 2010-01-18 00:00:00
First Entry Date/Time | First Activity Date | Hours | Day | Queue | SLA Standard |  | 2010-02-15 00:00:00
2010-01-01 01:55:38 | 2010-01-04 09:49:03 |  |  | C02 |  |  | 2010-05-31 00:00:00
2010-01-01 08:55:55 | 2010-01-04 09:49:09 |  |  | C08 |  |  | 2010-07-04 00:00:00
2010-01-02 10:08:38 | 2010-01-04 12:05:57 |  |  | C09 |  |  | 2010-09-06 00:00:00
2010-01-02 10:18:20 | 2010-01-04 11:39:53 |  |  | C10 |  |  | 2010-10-11 00:00:00
2010-01-03 13:55:36 | 2010-01-05 17:12:04 |  |  | C11 |  |  | 2010-11-11 00:00:00
2010-01-03 14:26:41 | 2010-01-04 13:47:31 |  |  | C12 |  |  | 2010-11-25 00:00:00
2010-01-03 16:15:39 | 2010-01-04 10:15:59 |  |  | C16 |  |  | 2010-12-25 00:00:00
2010-01-04 08:43:10 | 2010-01-06 13:57:36 |  |  | C17 |  |  | 2010-01-02 00:00:00
2010-01-04 17:06:11 | 2010-01-06 17:07:18 |  |  | C02 |  |  | 2010-01-03 00:00:00
2010-01-04 17:08:58 | 2010-01-05 08:32:47 |  |  | C30 |  |  | 2010-01-09 00:00:00
2010-01-04 17:09:48 | 2010-01-05 10:23:56 |  |  | C32 |  |  | 2010-01-10 00:00:00
2010-01-04 18:16:18 | 2010-01-05 10:15:32 |  |  | C33 |  |  | 2010-01-16 00:00:00
2010-01-04 18:19:51 | 2010-01-05 07:59:59 |  |  | C34 |  |  | 2010-01-17 00:00:00
2010-01-05 01:53:01 | 2010-01-05 13:31:36 |  |  | C50 |  |  | 2010-01-23 00:00:00
2010-01-05 01:53:06 | 2010-01-05 08:42:54 |  |  | C02 |  |  | 2010-01-24 00:00:00
2010-01-05 01:58:15 | 2010-01-06 17:16:38 |  |  | C08 |  |  | 2010-01-30 00:00:00
2010-01-05 01:58:24 | 2010-01-05 09:11:48 |  |  | C09 |  |  | 2010-01-31 00:00:00
2010-01-05 01:58:32 | 2010-01-06 17:19:04 |  |  | C10 |  |  | 2010-02-06 00:00:00
2010-01-05 01:58:34 | 2010-01-14 07:59:28 |  |  | C11 |  |  | 2010-02-07 00:00:00
2010-01-06 16:35:31 | 2010-01-08 16:54:28 |  |  | C12 |  |  | 2010-02-13 00:00:00
2010-01-06 16:36:10 | 2010-01-07 10:32:31 |  |  | C16 |  |  | 2010-02-14 00:00:00
2010-01-06 17:06:31 | 2010-01-13 09:02:01 |  |  | C17 |  |  | 2010-02-20 00:00:00
2010-01-06 17:07:14 | 2010-01-08 09:46:01 |  |  | C29 |  |  | 2010-02-21 00:00:00
2010-01-08 16:42:04 | 2010-01-12 18:10:20 |  |  | C30 |  |  | 2010-02-27 00:00:00
2010-01-08 16:42:38 | 2010-01-12 18:10:29 |  |  | C32 |  |  | 2010-02-28 00:00:00
2010-01-08 16:42:52 | 2010-01-13 08:26:42 |  |  | C33 |  |  | 2010-03-06 00:00:00
 |  |  |  |  |  |  | 2010-03-07 00:00:00
 |  |  |  |  |  |  | 2010-03-13 00:00:00
 |  |  |  |  |  |  | 2010-03-14 00:00:00
 |  |  |  |  |  |  | 2010-03-20 00:00:00
 |  |  |  |  |  |  | 2010-03-21 00:00:00
 |  |  |  |  |  |  | 2010-03-27 00:00:00
 |  |  |  |  |  |  | 2010-03-28 00:00:00
 |  |  |  |  |  |  | 2010-04-03 00:00:00
 |  |  |  |  |  |  | 2010-04-04 00:00:00
 |  |  |  |  |  |  | 2010-04-10 00:00:00
 |  |  |  |  |  |  | 2010-04-11 00:00:00
 |  |  |  |  |  |  | 2010-04-17 00:00:00
 |  |  |  |  |  |  | 2010-04-18 00:00:00
 |  |  |  |  |  |  | 2010-04-24 00:00:00
 |  |  |  |  |  |  | 2010-04-25 00:00:00
 |  |  |  |  |  |  | 2010-05-01 00:00:00
 |  |  |  |  |  |  | 2010-05-02 00:00:00
 |  |  |  |  |  |  | 2010-05-08 00:00:00
 |  |  |  |  |  |  | 2010-05-09 00:00:00
 |  |  |  |  |  |  | 2010-05-15 00:00:00
 |  |  |  |  |  |  | 2010-05-16 00:00:00
 |  |  |  |  |  |  | 2010-05-22 00:00:00
 |  |  |  |  |  |  | 2010-05-23 00:00:00
 |  |  |  |  |  |  | 2010-05-29 00:00:00
 |  |  |  |  |  |  | 2010-05-30 00:00:00
 |  |  |  |  |  |  | 2010-06-05 00:00:00
 |  |  |  |  |  |  | 2010-06-06 00:00:00
 |  |  |  |  |  |  | 2010-06-12 00:00:00
 |  |  |  |  |  |  | 2010-06-13 00:00:00
 |  |  |  |  |  |  | 2010-06-19 00:00:00
 |  |  |  |  |  |  | 2010-06-20 00:00:00
 |  |  |  |  |  |  | 2010-06-26 00:00:00
 |  |  |  |  |  |  | 2010-06-27 00:00:00
 |  |  |  |  |  |  | 2010-07-03 00:00:00
 |  |  |  |  |  |  | 2010-07-04 00:00:00
 |  |  |  |  |  |  | 2010-07-10 00:00:00
 |  |  |  |  |  |  | 2010-07-11 00:00:00
 |  |  |  |  |  |  | 2010-07-17 00:00:00
 |  |  |  |  |  |  | 2010-07-18 00:00:00
 |  |  |  |  |  |  | 2010-07-24 00:00:00
 |  |  |  |  |  |  | 2010-07-25 00:00:00
 |  |  |  |  |  |  | 2010-07-31 00:00:00
 |  |  |  |  |  |  | 2010-08-07 00:00:00
 |  |  |  |  |  |  | 2010-08-08 00:00:00
 |  |  |  |  |  |  | 2010-08-14 00:00:00
 |  |  |  |  |  |  | 2010-08-15 00:00:00
 |  |  |  |  |  |  | 2010-08-21 00:00:00
 |  |  |  |  |  |  | 2010-08-22 00:00:00
 |  |  |  |  |  |  | 2010-08-28 00:00:00
 |  |  |  |  |  |  | 2010-08-29 00:00:00
 |  |  |  |  |  |  | 2010-09-04 00:00:00
 |  |  |  |  |  |  | 2010-09-05 00:00:00
 |  |  |  |  |  |  | 2010-09-11 00:00:00
 |  |  |  |  |  |  | 2010-09-12 00:00:00
 |  |  |  |  |  |  | 2010-09-18 00:00:00
 |  |  |  |  |  |  | 2010-09-19 00:00:00
 |  |  |  |  |  |  | 2010-09-25 00:00:00
 |  |  |  |  |  |  | 2010-09-26 00:00:00
 |  |  |  |  |  |  | 2010-10-02 00:00:00
 |  |  |  |  |  |  | 2010-10-03 00:00:00
 |  |  |  |  |  |  | 2010-10-09 00:00:00
 |  |  |  |  |  |  | 2010-10-10 00:00:00
 |  |  |  |  |  |  | 2010-10-16 00:00:00
 |  |  |  |  |  |  | 2010-10-17 00:00:00
 |  |  |  |  |  |  | 2010-10-23 00:00:00
 |  |  |  |  |  |  | 2010-10-24 00:00:00
 |  |  |  |  |  |  | 2010-10-30 00:00:00
 |  |  |  |  |  |  | 2010-10-31 00:00:00
 |  |  |  |  |  |  | 2010-11-06 00:00:00
 |  |  |  |  |  |  | 2010-11-07 00:00:00
 |  |  |  |  |  |  | 2010-11-13 00:00:00
 |  |  |  |  |  |  | 2010-11-14 00:00:00
 |  |  |  |  |  |  | 2010-11-20 00:00:00
 |  |  |  |  |  |  | 2010-11-21 00:00:00
 |  |  |  |  |  |  | 2010-11-27 00:00:00
 |  |  |  |  |  |  | 2010-11-28 00:00:00
 |  |  |  |  |  |  | 2010-12-04 00:00:00
 |  |  |  |  |  |  | 2010-12-05 00:00:00
 |  |  |  |  |  |  | 2010-12-11 00:00:00
 |  |  |  |  |  |  | 2010-12-12 00:00:00
 |  |  |  |  |  |  | 2010-12-18 00:00:00
 |  |  |  |  |  |  | 2010-12-19 00:00:00
 |  |  |  |  |  |  | 2010-12-26 00:00:00