Spreadsheet: 164797d1340893288-paste-special-help-query-book1
Sheet: Sheet1

Date Received | Time Received | Assigned to | Assigned Date | Assigned Time | Date Completed | Time Completed | Total Time Taken |  |  | Example 1
2012-05-31 00:00:00 | 11:35:00 | Nilesh | 2012-06-01 00:00:00 | 13:23:00 | 2012-06-01 00:00:00 | 14:13:00 | 50 |  |  | 2012-05-31 00:00:00
2012-05-31 00:00:00 | 14:45:00 | Avinash | 2012-06-01 00:00:00 | 11:58:00 | 2012-06-01 00:00:00 | 12:28:00 | 28 |  |  | 2012-05-31 00:00:00
2012-05-31 00:00:00 | 14:45:00 | Nilesh | 2012-06-01 00:00:00 | 15:48:00 | 2012-06-01 00:00:00 | 16:44:00 | 56 |  |  | 2012-05-31 00:00:00
2012-05-31 00:00:00 | 14:45:00 | Nilesh | 2012-06-01 00:00:00 | 08:31:00 | 2012-06-01 00:00:00 | 08:53:00 | 22 |  |  | 2012-05-31 00:00:00
2012-05-31 00:00:00 | 14:45:00 | Avinash | 2012-06-01 00:00:00 | 09:37:00 | 2012-06-01 00:00:00 | 09:57:00 | 20 |  |  | 2012-05-31 00:00:00
2012-05-31 00:00:00 | 14:45:00 | Avinash | 2012-06-01 00:00:00 | 08:53:00 | 2012-06-01 00:00:00 | 09:19:00 | 26 |  |  | 2012-06-01 00:00:00
2012-05-31 00:00:00 | 14:45:00 | Nilesh | 2012-06-01 00:00:00 | 14:14:00 | 2012-06-01 00:00:00 | 15:10:00 | 36 |  |  | 2012-06-01 00:00:00
2012-05-31 00:00:00 | 14:45:00 | Avinash | 2012-06-01 00:00:00 | 15:18:00 | 2012-06-01 00:00:00 | 15:52:00 | 37 |  |  | 2012-06-01 00:00:00
2012-05-31 00:00:00 | 14:45:00 | Nilesh | 2012-06-01 00:00:00 | 09:25:00 | 2012-06-01 00:00:00 | 10:04:00 | 39 |  |  | 2012-06-01 00:00:00
2012-05-31 00:00:00 | 14:45:00 | Avinash | 2012-06-01 00:00:00 | 08:22:00 | 2012-06-01 00:00:00 | 08:35:00 | 13 |  |  | 2012-06-01 00:00:00
2012-06-01 00:00:00 | 11:00:00 | Nilesh | 2012-06-01 00:00:00 | 10:30:00 | 2012-06-01 00:00:00 | 11:47:00 | 22 |  |  | 2012-06-06 00:00:00
2012-06-01 00:00:00 | 11:00:00 | Nilesh | 2012-06-01 00:00:00 | 11:48:00 | 2012-06-01 00:00:00 | 12:19:00 | 31 |  |  | 2012-06-06 00:00:00
2012-06-01 00:00:00 | 12:26:00 | Avinash | 2012-06-05 00:00:00 | 10:23:00 | 2012-06-05 00:00:00 | 11:42:00 | 52 |  |  | 2012-06-07 00:00:00
2012-06-01 00:00:00 | 12:26:00 | Avinash | 2012-06-01 00:00:00 | 12:28:00 | 2012-06-01 00:00:00 | 12:55:00 | 27 |  |  | 2012-06-07 00:00:00
2012-06-01 00:00:00 | 17:00:00 | Avinash | 2012-06-05 00:00:00 | 08:16:00 | 2012-06-05 00:00:00 | 08:42:00 | 26 |  |  | 2012-06-07 00:00:00
2012-06-01 00:00:00 | 17:00:00 | Nilesh | 2012-06-05 00:00:00 | 14:59:00 | 2012-06-05 00:00:00 | 15:52:00 | 53 |  |  | 2012-06-07 00:00:00
2012-06-01 00:00:00 | 17:00:00 | Avinash | 2012-06-05 00:00:00 | 13:35:00 | 2012-06-05 00:00:00 | 14:19:00 | 44 |  |  | 2012-06-07 00:00:00
2012-06-01 00:00:00 | 17:00:00 | Nilesh | 2012-06-05 00:00:00 | 10:33:00 | 2012-06-05 00:00:00 | 11:54:00 | 51 |  |  | 2012-06-07 00:00:00
2012-06-01 00:00:00 | 17:00:00 | Nilesh | 2012-06-05 00:00:00 | 10:33:00 | 2012-06-05 00:00:00 | 10:11:00 | 48 |  |  | 2012-06-07 00:00:00
2012-06-01 00:00:00 | 17:00:00 | Avinash | 2012-06-05 00:00:00 | 10:33:00 | 2012-06-05 00:00:00 | 09:00:00 | 18 |  |  | 2012-06-07 00:00:00
2012-06-01 00:00:00 | 17:00:00 | Avinash | 2012-06-05 00:00:00 | 10:33:00 | 2012-06-05 00:00:00 | 12:07:00 | 24 |  |  | 2012-06-07 00:00:00
2012-06-01 00:00:00 | 17:00:00 | Avinash | 2012-06-06 00:00:00 | 08:57:00 | 2012-06-06 00:00:00 | 09:27:00 | 30 |  |  | 2012-06-08 00:00:00
2012-06-01 00:00:00 | 17:00:00 | Avinash | 2012-06-06 00:00:00 | 08:34:00 | 2012-06-06 00:00:00 | 08:57:00 | 23 |  |  | 2012-06-08 00:00:00
2012-06-06 00:00:00 | 11:34:00 | Avinash | 2012-06-06 00:00:00 | 11:37:00 | 2012-06-06 00:00:00 | 12:23:00 | 46 |  |  | 2012-06-08 00:00:00
2012-06-06 00:00:00 | 11:34:00 | Avinash | 2012-06-06 00:00:00 | 14:29:00 | 2012-06-06 00:00:00 | 15:16:00 | 17 |  |  | 2012-06-08 00:00:00
2012-06-06 00:00:00 | 11:34:00 | Nilesh | 2012-06-06 00:00:00 | 12:29:00 | 2012-06-06 00:00:00 | 13:13:00 | 44 |  |  | 2012-06-08 00:00:00
2012-06-06 00:00:00 | 17:00:00 | Nilesh | 2012-06-07 00:00:00 | 13:21:00 | 2012-06-07 00:00:00 | 14:21:00 | 60 |  |  | 2012-06-08 00:00:00
2012-06-06 00:00:00 | 17:00:00 | Avinash | 2012-06-07 00:00:00 | 12:56:00 | 2012-06-07 00:00:00 | 13:22:00 | 26 |  |  | 2012-06-08 00:00:00
2012-06-07 00:00:00 | 12:35:00 | Avinash | 2012-06-07 00:00:00 | 12:41:00 | 2012-06-07 00:00:00 | 12:56:00 | 15 |  |  | 2012-06-08 00:00:00
2012-06-07 00:00:00 | 12:20:00 | Avinash | 2012-06-07 00:00:00 | 12:24:00 | 2012-06-07 00:00:00 | 12:41:00 | 17 |  |  | 2012-06-08 00:00:00
2012-06-07 00:00:00 | 13:20:00 | Avinash | 2012-06-07 00:00:00 | 13:22:00 | 2012-06-07 00:00:00 | 13:52:00 | 30 |  |  | 2012-06-11 00:00:00
2012-06-07 00:00:00 | 13:50:00 | Avinash | 2012-06-07 00:00:00 | 13:52:00 | 2012-06-07 00:00:00 | 16:04:00 | 99 |  |  | 2012-06-11 00:00:00
2012-06-07 00:00:00 | 15:50:00 | Nilesh | 2012-06-07 00:00:00 | 15:56:00 | 2012-06-07 00:00:00 | 16:21:00 | 25 |  |  | 2012-06-11 00:00:00
2012-06-07 00:00:00 | 14:20:00 | Nilesh | 2012-06-07 00:00:00 | 14:22:00 | 2012-06-07 00:00:00 | 15:55:00 | 78 |  |  | 2012-06-11 00:00:00
2012-06-07 00:00:00 | 12:10:00 | Nilesh | 2012-06-07 00:00:00 | 12:13:00 | 2012-06-07 00:00:00 | 12:45:00 | 32 |  |  | 2012-06-11 00:00:00
2012-06-07 00:00:00 | 11:00:00 | Nilesh | 2012-06-07 00:00:00 | 11:10:00 | 2012-06-07 00:00:00 | 11:38:00 | 28 |  |  | 2012-06-11 00:00:00
2012-06-07 00:00:00 | 11:20:00 | Nilesh | 2012-06-07 00:00:00 | 11:39:00 | 2012-06-07 00:00:00 | 12:12:00 | 33 |  |  | 2012-06-12 00:00:00
2012-06-07 00:00:00 | 12:40:00 | Nilesh | 2012-06-07 00:00:00 | 12:46:00 | 2012-06-07 00:00:00 | 13:20:00 | 34 |  |  | 2012-06-12 00:00:00
2012-06-07 00:00:00 | 17:22:00 | Nilesh | 2012-06-12 00:00:00 | 08:36:00 | 2012-06-12 00:00:00 | 09:36:00 | 60 |  |  | 2012-06-12 00:00:00
2012-06-07 00:00:00 | 17:22:00 | Nilesh | 2012-06-11 00:00:00 | 15:53:00 | 2012-06-11 00:00:00 | 17:00:00 | 67 |  |  | 2012-06-12 00:00:00
2012-06-07 00:00:00 | 17:22:00 | Avinash | 2012-06-08 00:00:00 | 16:34:00 | 2012-06-08 00:00:00 | 17:03:00 | 29 |  |  | 2012-06-12 00:00:00
2012-06-07 00:00:00 | 17:22:00 | Nilesh | 2012-06-08 00:00:00 | 08:24:00 | 2012-06-08 00:00:00 | 08:46:00 | 22 |  |  | 2012-06-13 00:00:00
2012-06-07 00:00:00 | 17:22:00 | Avinash | 2012-06-11 00:00:00 | 14:39:00 | 2012-06-11 00:00:00 | 15:33:00 | 30 |  |  | 2012-06-13 00:00:00
2012-06-08 00:00:00 | 11:11:00 | Nilesh | 2012-06-08 00:00:00 | 11:10:00 | 2012-06-08 00:00:00 | 11:34:00 | 24
2012-06-08 00:00:00 | 11:25:00 | Nilesh | 2012-06-08 00:00:00 | 12:26:00 | 2012-06-08 00:00:00 | 12:58:00 | 32
2012-06-08 00:00:00 | 11:40:00 | Nilesh | 2012-06-08 00:00:00 | 12:59:00 | 2012-06-08 00:00:00 | 15:18:00 | 49
2012-06-08 00:00:00 | 11:40:00 | Nilesh | 2012-06-08 00:00:00 | 15:19:00 | 2012-06-08 00:00:00 | 16:33:00 | 74
2012-06-08 00:00:00 | 12:50:00 | Nilesh | 2012-06-11 00:00:00 | 08:21:00 | 2012-06-11 00:00:00 | 09:06:00 | 45
2012-06-08 00:00:00 | 12:50:00 | Avinash | 2012-06-11 00:00:00 | 14:13:00 | 2012-06-11 00:00:00 | 14:39:00 | 26 |  |  | 2012-06-15 00:00:00
2012-06-08 00:00:00 | 12:50:00 | Nilesh | 2012-06-12 00:00:00 | 14:31:00 | 2012-06-12 00:00:00 | 15:03:00 | 32
2012-06-08 00:00:00 | 16:50:00 | Avinash | 2012-06-12 00:00:00 | 14:05:00 | 2012-06-12 00:00:00 | 15:39:00 | 52 |  |  | 2012-06-15 00:00:00
2012-06-08 00:00:00 | 16:00:00 | Avinash | 2012-06-07 00:00:00 | 15:19:00 | 2012-06-08 00:00:00 |  | 20 |  |  | 2012-06-15 00:00:00
2012-06-08 00:00:00 | 17:14:00 | Nilesh | 2012-06-12 00:00:00 | 13:02:00 | 2012-06-12 00:00:00 | 13:51:00 | 49
2012-06-08 00:00:00 | 17:14:00 | Nilesh | 2012-06-11 00:00:00 | 09:07:00 | 2012-06-11 00:00:00 | 09:24:00 | 17
2012-06-08 00:00:00 | 17:14:00 | Avinash | 2012-06-11 00:00:00 | 09:29:00 | 2012-06-11 00:00:00 | 09:42:00 | 13 |  |  | 2012-06-19 00:00:00
2012-06-08 00:00:00 | 17:14:00 | Avinash | 2012-06-12 00:00:00 | 09:40:00 | 2012-06-12 00:00:00 | 10:18:00 | 38 |  |  | 2012-06-19 00:00:00
2012-06-08 00:00:00 | 17:14:00 | Nilesh | 2012-06-12 00:00:00 | 06:00:00 | 2012-06-13 00:00:00 | 06:32:00 | 88
2012-06-08 00:00:00 | 17:14:00 | Avinash | 2012-06-12 00:00:00 | 10:18:00 | 2012-06-12 00:00:00 | 11:35:00 | 36 |  |  | 2012-06-19 00:00:00
2012-06-11 00:00:00 | 12:00:00 | Nilesh | 2012-06-11 00:00:00 | 13:02:00 | 2012-06-11 00:00:00 | 13:47:00 | 45
2012-06-11 00:00:00 | 12:00:00 | Nilesh | 2012-06-11 00:00:00 | 11:31:00 | 2012-06-11 00:00:00 | 12:06:00 | 35
2012-06-11 00:00:00 | 16:23:00 | Nilesh | 2012-06-12 00:00:00 | 06:00:00 | 2012-06-12 00:00:00 | 06:27:00 | 27
2012-06-11 00:00:00 | 16:23:00 | Nilesh | 2012-06-12 00:00:00 | 09:37:00 | 2012-06-12 00:00:00 | 10:01:00 | 24
2012-06-11 00:00:00 | 16:23:00 | Avinash | 2012-06-12 00:00:00 | 09:02:00 | 2012-06-12 00:00:00 | 09:22:00 | 20 |  |  | 2012-06-20 00:00:00
2012-06-11 00:00:00 | 16:23:00 | Nilesh | 2012-06-13 00:00:00 | 10:19:00 | 2012-06-13 00:00:00 | 11:31:00 | 42
2012-06-11 00:00:00 | 16:23:00 | Nilesh | 2012-06-13 00:00:00 | 15:31:00 | 2012-06-13 00:00:00 | 16:15:00 | 44
2012-06-11 00:00:00 | 16:23:00 | Avinash | 2012-06-13 00:00:00 | 16:16:00 | 2012-06-13 00:00:00 | 17:03:00 | 47 |  |  | 2012-06-20 00:00:00
2012-06-12 00:00:00 | 12:02:00 | Avinash | 2012-06-12 00:00:00 | 13:09:00 | 2012-06-12 00:00:00 | 13:38:00 | 29 |  |  | 2012-06-20 00:00:00
2012-06-12 00:00:00 | 12:30:00 | Avinash | 2012-06-14 00:00:00 | 10:22:00 | 2012-06-14 00:00:00 | 11:20:00 | 21 |  |  | 2012-06-20 00:00:00
2012-06-12 00:00:00 | 12:30:00 | Jayesh | 2012-06-14 00:00:00 | 13:54:00 | 2012-06-14 00:00:00 | 14:35:00 | 41 |  |  | 2012-06-20 00:00:00
2012-06-12 00:00:00 | 12:30:00 | Avinash | 2012-06-12 00:00:00 | 13:38:00 | 2012-06-12 00:00:00 | 14:05:00 | 27 |  |  | 2012-06-21 00:00:00
2012-06-12 00:00:00 | 13:06:00 | Jayesh | 2012-06-14 00:00:00 | 09:24:00 | 2012-06-14 00:00:00 | 10:10:00 | 46 |  |  | 2012-06-21 00:00:00
2012-06-12 00:00:00 | 13:06:00 | Nilesh | 2012-06-14 00:00:00 | 12:14:00 | 2012-06-14 00:00:00 | 12:54:00 | 40
2012-06-12 00:00:00 | 13:06:00 | Avinash | 2012-06-14 00:00:00 | 16:26:00 | 2012-06-14 00:00:00 | 17:01:00 |  |  |  | 2012-06-22 00:00:00
2012-06-12 00:00:00 | 13:06:00 | Avinash | 2012-06-14 00:00:00 | 11:20:00 | 2012-06-14 00:00:00 | 11:47:00 | 27 |  |  | 2012-06-22 00:00:00
2012-06-12 00:00:00 | 13:40:00 | Jayesh | 2012-06-14 00:00:00 | 16:28:00 | 2012-06-14 00:00:00 | 17:00:00 | 32 |  |  | 2012-06-22 00:00:00
2012-06-12 00:00:00 | 17:00:00 | Jayesh | 2012-06-14 00:00:00 | 13:11:00 | 2012-06-14 00:00:00 | 13:54:00 | 43 |  |  | 2012-06-22 00:00:00
2012-06-12 00:00:00 | 17:00:00 | Avinash | 2012-06-14 00:00:00 | 15:17:00 | 2012-06-14 00:00:00 | 15:53:00 | 36 |  |  | 2012-06-22 00:00:00
2012-06-12 00:00:00 | 17:00:00 | Nilesh | 2012-06-13 00:00:00 | 07:23:00 | 2012-06-13 00:00:00 | 08:08:00 | 45
2012-06-12 00:00:00 | 17:00:00 | Nilesh | 2012-06-14 00:00:00 | 14:12:00 | 2012-06-14 00:00:00 | 15:42:00 | 65
2012-06-12 00:00:00 | 17:00:00 | Avinash | 2012-06-14 00:00:00 | 15:53:00 | 2012-06-14 00:00:00 | 16:26:00 | 33
2012-06-12 00:00:00 | 17:00:00 | Nilesh | 2012-06-13 00:00:00 | 08:09:00 | 2012-06-13 00:00:00 | 08:41:00 | 32
2012-06-12 00:00:00 | 17:00:00 | Jayesh | 2012-06-14 00:00:00 | 15:43:00 | 2012-06-14 00:00:00 | 16:28:00 | 45
2012-06-12 00:00:00 | 17:00:00 | Nilesh | 2012-06-13 00:00:00 | 08:42:00 | 2012-06-13 00:00:00 | 09:22:00 | 40
2012-06-12 00:00:00 | 17:00:00 | Avinash | 2012-06-14 00:00:00 | 12:46:00 | 2012-06-14 00:00:00 | 13:20:00 | 34
2012-06-13 00:00:00 | 14:00:00 | Nilesh | 2012-06-13 00:00:00 | 14:45:00 | 2012-06-13 00:00:00 | 15:30:00 | 45
2012-06-13 00:00:00 | 17:19:00 | Jayesh | 2012-06-15 00:00:00 | 14:40:00 | 2012-06-15 00:00:00 | 17:00:00 | 85
2012-06-13 00:00:00 | 17:19:00 | Jayesh | 2012-06-14 00:00:00 | 08:45:00 | 2012-06-14 00:00:00 | 09:24:00 | 39
2012-06-13 00:00:00 | 17:19:00 | Jayesh | 2012-06-16 00:00:00 | 06:00:00 | 2012-06-16 00:00:00 | 06:45:00 | 35
2012-06-13 00:00:00 | 17:19:00 | Nilesh | 2012-06-14 00:00:00 | 08:51:00 | 2012-06-14 00:00:00 | 09:15:00 | 24
2012-06-13 00:00:00 | 17:19:00 | Jayesh | 2012-06-15 00:00:00 | 14:40:00 | 2012-06-26 00:00:00 | 15:00:00 | 39
2012-06-13 00:00:00 | 17:19:00 | Avinash | 2012-06-15 00:00:00 | 15:11:00 | 2012-06-15 00:00:00 | 15:37:00 | 26
2012-06-13 00:00:00 | 17:19:00 | Avinash | 2012-06-16 00:00:00 | 06:37:00 | 2012-06-16 00:00:00 | 07:06:00 | 29
2012-06-13 00:00:00 | 17:19:00 | Avinash | 2012-06-16 00:00:00 | 07:06:00 | 2012-06-16 00:00:00 | 07:35:00 | 29
2012-06-13 00:00:00 | 17:20:00 | Jayesh | 2012-06-16 00:00:00 | 09:33:00 | 2012-06-16 00:00:00 | 10:35:00 | 62
2012-06-13 00:00:00 | 17:20:00 | Avinash | 2012-06-16 00:00:00 | 08:57:00 | 2012-06-16 00:00:00 | 10:29:00 | 56
2012-06-13 00:00:00 | 17:20:00 | Avinash | 2012-06-15 00:00:00 | 15:37:00 | 2012-06-15 00:00:00 | 16:33:00 | 18
2012-06-13 00:00:00 | 17:20:00 | Avinash | 2012-06-14 00:00:00 | 08:51:00 | 2012-06-14 00:00:00 | 10:03:00 | 72
2012-06-13 00:00:00 | 13:40:00 | Avinash | 2012-06-13 00:00:00 | 13:45:00 | 2012-06-13 00:00:00 | 14:24:00 | 48
2012-06-13 00:00:00 | 15:40:00 | Avinash | 2012-06-13 00:00:00 | 15:47:00 | 2012-06-13 00:00:00 | 16:16:00 | 29