Spreadsheet: 47731d1246905888-time-calculation-ignore-weekend-time-calculation
Sheet: Sheet2

Spid | Request Date | Response Date | Time Taken (HH:MM) | Column1 | Column2 | Column3
180092 | 2009-06-02 10:16:35 | 2009-06-02 15:21:19 | 05:04:44 | 05:04:44 | #N/A
182666 | 2009-06-11 17:31:23 | 2009-06-12 08:55:20 | 00:25:20 | 00:25:20 | 0 | 0.354166666666667
181320 | 2009-06-05 17:16:48 | 2009-06-08 09:23:59 | 01:07:11 | 01:07:11 | 0 | 0.729166666666667
172900 | 2009-04-27 17:27:56 | 2009-04-28 13:35:11 | 05:07:15 | 05:07:15 | 0
172167 | 2009-04-23 17:14:44 | 2009-04-24 08:46:25 | 00:31:41 | 00:31:41 | 0
171139 | 2009-04-20 17:34:56 | 2009-04-21 08:35:59 | 00:05:59 | 00:05:59 | 0
169598 | 2009-04-14 17:41:29 | 2009-04-15 08:25:43 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
178441 | 2009-05-22 16:39:12 | 2009-05-26 09:34:01 | 01:54:49 | 01:54:49 | 0
 |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
170538 | 2009-04-17 13:20:02 | 2009-04-20 09:58:39 | 05:38:37 | 05:38:37 | 0
179630 | 2009-05-29 16:40:19 | 2009-06-01 13:12:50 | 05:32:31 | 05:32:31 | 0
170544 | 2009-04-17 13:37:17 | 2009-04-20 10:08:55 | 05:31:38 | 05:31:38 | 0
179554 | 2009-05-29 13:08:46 | 2009-06-01 09:10:12 | 05:01:26 | 05:01:26 | 0
170569 | 2009-04-17 14:29:55 | 2009-04-20 10:23:46 | 04:53:51 | 04:53:51 | 0
167721 | 2009-04-03 16:56:26 | 2009-04-06 09:18:30 | 01:22:04 | 01:22:04 | 0
179282 | 2009-05-28 12:16:46 | 2009-05-29 11:30:12 | 08:13:26 | 08:13:26 | 0
177705 | 2009-05-20 10:53:45 | 2009-05-21 09:45:26 | 07:51:41 | 07:51:41 | 0
172789 | 2009-04-27 14:20:09 | 2009-04-28 12:49:57 | 07:29:48 | 07:29:48 | 0
177650 | 2009-05-20 09:45:01 | 2009-05-21 08:09:35 | 07:44:59 | 07:44:59 | 0
179324 | 2009-05-28 13:36:44 | 2009-05-29 11:59:57 | 07:23:13 | 07:23:13 | 0
177757 | 2009-05-20 12:08:21 | 2009-05-21 10:06:41 | 06:58:20 | 06:58:20 | 0
170877 | 2009-04-20 11:37:08 | 2009-04-21 09:17:31 | 06:40:23 | 06:40:23 | 0
181863 | 2009-06-09 11:23:54 | 2009-06-10 08:55:58 | 06:32:04 | 06:32:04 | 0
168690 | 2009-04-08 11:51:04 | 2009-04-09 09:01:36 | 06:10:32 | 06:10:32 | 0
178989 | 2009-05-27 12:17:58 | 2009-05-28 09:24:28 | 06:06:30 | 06:06:30 | 0
180192 | 2009-06-02 12:53:31 | 2009-06-03 09:55:50 | 06:02:19 | 06:02:19 | 0
180169 | 2009-06-02 12:23:15 | 2009-06-03 09:21:56 | 05:58:41 | 05:58:41 | 0
172764 | 2009-04-27 13:29:52 | 2009-04-28 10:28:33 | 05:58:41 | 05:58:41 | 0
172745 | 2009-04-27 13:05:36 | 2009-04-28 09:50:12 | 05:44:36 | 05:44:36 | 0
170237 | 2009-04-16 14:17:45 | 2009-04-17 10:59:24 | 05:41:39 | 05:41:39 | 0
179920 | 2009-06-01 14:48:29 | 2009-06-02 11:05:48 | 05:17:19 | 05:17:19 | 0
171375 | 2009-04-21 13:23:04 | 2009-04-22 09:33:07 | 05:10:03 | 05:10:03 | 0
171366 | 2009-04-21 13:03:27 | 2009-04-22 09:12:16 | 05:08:49 | 05:08:49 | 0
178791 | 2009-05-26 15:52:30 | 2009-05-27 11:55:49 | 05:03:19 | 05:03:19 | 0
171031 | 2009-04-20 15:06:29 | 2009-04-21 11:06:42 | 05:00:13 | 05:00:13 | 0
171072 | 2009-04-20 15:59:19 | 2009-04-21 11:48:41 | 04:49:22 | 04:49:22 | 0
171073 | 2009-04-20 16:00:58 | 2009-04-21 11:50:06 | 04:49:08 | 04:49:08 | 0
171764 | 2009-04-22 14:31:37 | 2009-04-23 10:08:03 | 04:36:26 | 04:36:26 | 0
171092 | 2009-04-20 16:30:04 | 2009-04-21 12:02:08 | 04:32:04 | 04:32:04 | 0
170332 | 2009-04-16 16:44:25 | 2009-04-17 12:08:01 | 04:23:36 | 04:23:36 | 0
177532 | 2009-05-19 15:31:19 | 2009-05-20 10:48:53 | 04:17:34 | 04:17:34 | 0
169494 | 2009-04-14 14:41:53 | 2009-04-15 09:51:39 | 04:09:46 | 04:09:46 | 0
177179 | 2009-05-18 15:24:39 | 2009-05-19 10:24:03 | 03:59:24 | 03:59:24 | 0
173186 | 2009-04-28 16:27:24 | 2009-04-29 11:21:00 | 03:53:36 | 03:53:36 | 0
171835 | 2009-04-22 16:41:46 | 2009-04-23 11:27:11 | 03:45:25 | 03:45:25 | 0
171457 | 2009-04-21 16:19:50 | 2009-04-22 10:59:59 | 03:40:09 | 03:40:09 | 0
169549 | 2009-04-14 16:04:06 | 2009-04-15 10:30:01 | 03:25:55 | 03:25:55 | 0
172074 | 2009-04-23 14:40:53 | 2009-04-24 09:02:26 | 03:21:33 | 03:21:33 | 0
181022 | 2009-06-04 16:13:31 | 2009-06-05 08:52:02 | 01:38:31 | 01:38:31 | 0
181702 | 2009-06-08 16:44:14 | 2009-06-09 08:27:47 | 00:45:46 | 00:45:46 | 0
181721 | 2009-06-08 17:19:21 | 2009-06-09 08:13:21 | 00:10:39 | 00:10:39 | 0
173592 | 2009-04-30 09:31:17 | 2009-04-30 17:00:51 | 07:29:34 | 07:29:34 | 0
179446 | 2009-05-29 08:19:33 | 2009-05-29 15:41:05 | 07:21:32 | 07:21:32 | 0
178878 | 2009-05-27 09:03:01 | 2009-05-27 16:17:53 | 07:14:52 | 07:14:52 | 0
170762 | 2009-04-20 09:22:28 | 2009-04-20 16:29:11 | 07:06:43 | 07:06:43 | 0
179459 | 2009-05-29 08:57:40 | 2009-05-29 15:48:12 | 06:50:32 | 06:50:32 | 0
179461 | 2009-05-29 09:03:04 | 2009-05-29 15:49:22 | 06:46:18 | 06:46:18 | 0
169121 | 2009-04-09 16:12:05 | 2009-04-14 09:27:02 | 02:14:57 | 02:14:57 | 0
172298 | 2009-04-24 11:20:14 | 2009-04-27 08:34:44 | 06:14:30 | 06:14:30 | 0
172383 | 2009-04-24 13:59:04 | 2009-04-27 10:51:47 | 05:52:43 | 05:52:43 | 0
168065 | 2009-04-06 14:43:19 | 2009-04-07 10:30:09 | 04:46:50 | 04:46:50 | 0
169478 | 2009-04-14 14:16:40 | 2009-04-15 09:58:37 | 04:41:57 | 04:41:57 | 0
178137 | 2009-05-21 13:33:08 | 2009-05-22 08:38:20 | 04:05:12 | 04:05:12 | 0
169505 | 2009-04-14 14:59:24 | 2009-04-15 09:59:17 | 03:59:53 | 03:59:53 | 0
171791 | 2009-04-22 15:37:59 | 2009-04-23 10:33:54 | 03:55:55 | 03:55:55 | 0
166997 | 2009-04-01 15:03:08 | 2009-04-02 09:24:18 | 03:21:10 | 03:21:10 | 0
171801 | 2009-04-22 15:54:50 | 2009-04-23 09:21:21 | 02:26:31 | 02:26:31 | 0
177676 | 2009-05-20 10:18:39 | 2009-05-20 16:16:47 | 05:58:08 | 05:58:08 | 0
173009 | 2009-04-28 10:53:59 | 2009-04-28 16:13:10 | 05:19:11 | 05:19:11 | 0
179412 | 2009-05-28 16:31:19 | 2009-05-29 12:00:51 | 04:29:32 | 04:29:32 | 0
172128 | 2009-04-23 16:01:10 | 2009-04-24 10:15:13 | 03:14:03 | 03:14:03 | 0
182365 | 2009-06-10 17:11:12 | 2009-06-11 11:01:21 | 02:50:09 | 02:50:09 | 0
169591 | 2009-04-14 17:12:41 | 2009-04-15 10:18:29 | 02:05:48 | 02:05:48 | 0
170421 | 2009-04-17 10:02:50 | 2009-04-17 16:15:13 | 06:12:23 | 06:12:23 | 0
172197 | 2009-04-24 08:52:39 | 2009-04-24 14:46:17 | 05:53:38 | 05:53:38 | 0
179442 | 2009-05-29 08:10:01 | 2009-05-29 13:26:11 | 05:16:10 | 05:16:10 | 0
179588 | 2009-05-29 14:47:42 | 2009-06-01 09:29:22 | 03:41:40 | 03:41:40 | 0
179347 | 2009-05-28 14:28:28 | 2009-05-29 14:12:35 | 08:44:07 | 08:44:07 | 0
180529 | 2009-06-03 12:39:11 | 2009-06-04 10:19:16 | 06:40:05 | 06:40:05 | 0
177887 | 2009-05-20 15:36:02 | 2009-05-21 11:57:04 | 05:21:02 | 05:21:02 | 0
177579 | 2009-05-19 17:03:33 | 2009-05-20 12:29:47 | 04:26:14 | 04:26:14 | 0
177576 | 2009-05-19 16:56:32 | 2009-05-20 12:05:35 | 04:09:03 | 04:09:03 | 0
169978 | 2009-04-15 17:23:24 | 2009-04-16 12:16:54 | 03:53:30 | 03:53:30 | 0
179964 | 2009-06-01 16:14:12 | 2009-06-02 10:37:17 | 03:23:05 | 03:23:05 | 0
172903 | 2009-04-28 07:55:44 | 2009-04-28 16:37:09 | 08:41:25 | 08:41:25 | 0
169217 | 2009-04-14 08:41:53 | 2009-04-14 15:28:53 | 06:47:00 | 06:47:00 | 0
169989 | 2009-04-16 08:12:15 | 2009-04-16 14:42:49 | 06:30:34 | 06:30:34 | 0
171273 | 2009-04-21 10:54:31 | 2009-04-21 16:36:53 | 05:42:22 | 05:42:22 | 0
172643 | 2009-04-27 10:20:35 | 2009-04-27 16:00:35 | 05:40:00 | 05:40:00 | 0