Spreadsheet: 76602d1277150287-calculate-net-working-hours-book1
Sheet: Sheet1

Date of Complaint / Request | Assigned Date & Time (Cdops) | Call Status | Final Status | Closure Date & Time | TAT End Time | Wrking hours Taken | TAT Adherence
2010-06-14 12:20:00 | 2010-06-16 09:20:00 | Other | Pending | 2010-06-17 17:59:00
2010-06-14 12:44:00 | 2010-06-16 21:22:00 | Resolved | Resolved (SMS Sent) | 2010-06-17 17:20:00
2010-06-14 12:48:00 | 2010-06-16 20:24:00 | Resolved | Resolved | 2010-06-17 14:09:00
2010-06-14 13:34:00 | 2010-06-16 21:22:00 | Resolved | Resolved | 2010-06-17 16:16:00
2010-06-14 18:19:00 | 2010-06-16 21:22:00 | Resolved | Resolved | 2010-06-17 16:17:00
2010-06-14 18:28:00 | 2010-06-16 21:21:00 | Resolved | Resolved | 2010-06-17 12:22:00
2010-06-15 14:00:00 | 2010-06-16 19:56:00 | Other | Resolved | 2010-06-17 17:51:00
2010-06-15 15:26:00 | 2010-06-16 20:40:00 | Other | Resolved | 2010-06-17 14:46:00
2010-06-15 15:45:00 | 2010-06-16 21:04:00 | Resolved | Resolved | 2010-06-17 17:59:00
2010-06-15 16:16:00 | 2010-06-16 20:39:00 | Resolved | Resolved | 2010-06-17 18:43:00
2010-06-15 19:47:00 | 2010-06-16 20:37:00 | Resolved | Resolved | 2010-06-17 17:53:00
2010-06-15 15:30:00 | 2010-06-17 15:14:00 | Resolved | Resolved | 2010-06-18 15:51:00
2010-06-15 15:50:00 | 2010-06-17 20:13:00 | Other | Resolved | 2010-06-18 15:31:00
2010-06-15 16:11:00 | 2010-06-17 20:12:00 | Other | Resolved | 2010-06-18 12:05:00
2010-06-15 18:12:00 | 2010-06-17 20:12:00 | Other | Resolved | 2010-06-18 15:38:00
2010-06-16 12:48:00 | 2010-06-17 20:10:00 | Number Not Reachable | Resolved | 2010-06-18 16:16:00
2010-06-16 13:30:00 | 2010-06-17 20:11:00 | Other | Resolved | 2010-06-18 10:07:00
2010-06-16 15:30:00 | 2010-06-17 20:11:00 | Other | Resolved | 2010-06-18 13:38:00
2010-06-16 16:36:00 | 2010-06-17 20:12:00 | Other | Resolved | 2010-06-18 13:36:00
2010-06-16 17:00:00 | 2010-06-17 20:15:00 | Resolved | Resolved | 2010-06-18 10:16:00
2010-06-16 18:20:00 | 2010-06-17 20:16:00 | Resolved | Resolved | 2010-06-18 15:18:00
2010-06-16 18:14:00 | 2010-06-18 15:16:00 | Resolved | Resolved | 2010-06-18 17:55:00
2010-06-16 18:44:00 | 2010-06-18 10:01:00 | Ringing | Resolved (SMS Sent) | 2010-06-18 17:48:00
2010-06-16 12:51:00 | 2010-06-19 09:37:00 | Resolved | Resolved | 2010-06-19 17:43:00
2010-06-17 12:53:00 | 2010-06-19 09:30:00 | Other | Resolved | 2010-06-19 10:07:00
2010-06-17 13:08:00 | 2010-06-19 09:30:00 | Other | Resolved | 2010-06-19 10:08:00
2010-06-17 15:57:00 | 2010-06-19 09:30:00 | Other | Resolved | 2010-06-19 10:08:00
2010-06-17 16:24:00 | 2010-06-19 09:33:00 | Ringing | Resolved (SMS Sent) | 2010-06-19 17:58:00
2010-06-17 18:36:00 | 2010-06-19 09:34:00 | Resolved | Resolved | 2010-06-19 17:53:00
2010-06-17 18:50:00 | 2010-06-19 09:31:00 | Other | Resolved | 2010-06-19 10:19:00
2010-06-17 19:02:00 | 2010-06-19 09:32:00 | Number Not Reachable | Resolved | 2010-06-19 18:09:00
2010-06-16 11:42:00 | 2010-06-19 16:51:00 | Number Not Reachable | Resolved (SMS Sent) | 2010-06-21 15:10:00 |  |  |  | 40349.70833333334
2010-06-16 12:19:00 | 2010-06-19 16:49:00 | Resolved | Resolved | 2010-06-21 15:08:00
2010-06-16 13:08:00 | 2010-06-19 16:51:00 | Resolved | Resolved | 2010-06-21 15:15:00
2010-06-17 10:17:00 | 2010-06-19 16:46:00 | Resolved | Resolved | 2010-06-21 10:51:00
2010-06-17 20:24:00 | 2010-06-19 16:51:00 | Ringing | Resolved | 2010-06-21 17:06:00