Spreadsheet: 21926d1210153667-slightly-complex-conversion-and-date-calculation-sample
Sheet: Sheet1

Create Time | Start Time | SD Start time | TAT Stop Time | TAT Target Time | Case Create | TAT Start | Result TAT
Thu 2008-01-03 13:46 | Thu 2008-01-03 13:46 | Thu 2008-01-03 14:03 | 2008-01-03 14:03:50 | 2008-01-03 17:00:00 | 2008-01-03 13:46:00 | 2008-01-03 14:03:00 | 39450 days 00:00:50
Thu 2008-01-03 13:46 | Thu 2008-01-03 13:46 | Thu 2008-01-03 14:34 | 2008-01-03 14:35:03 | 2008-01-03 14:46:59 | 2008-01-03 13:46:00 | 2008-01-03 14:34:00 | 39450 days 00:01:03
Thu 2008-01-03 14:11 | Thu 2008-01-03 14:11 | Thu 2008-01-03 14:31 | 2008-01-03 14:31:49 | 2008-01-03 15:11:47 | 2008-01-03 14:11:00 | 2008-01-03 14:31:00 | 39450 days 00:00:49
Thu 2008-01-03 14:39 | Thu 2008-01-03 14:39 | Thu 2008-01-03 15:03 | 2008-01-03 15:04:12 | 2008-01-03 15:24:12 | 2008-01-03 14:39:00 | 2008-01-03 15:03:00 | 39450 days 00:01:12
Thu 2008-01-03 14:46 | Thu 2008-01-03 14:46 | Thu 2008-01-03 15:17 | 2008-01-03 15:19:32 | 2008-01-03 15:46:38 | 2008-01-03 14:46:00 | 2008-01-03 15:17:00 | 39450 days 00:02:32
Thu 2008-01-03 14:54 | Thu 2008-01-03 14:54 | Thu 2008-01-03 15:12 | 2008-01-03 15:12:51 | 2008-01-03 17:30:00 | 2008-01-03 14:54:00 | 2008-01-03 15:12:00 | 39450 days 00:00:51
Fri 2008-01-04 09:33 | Fri 2008-01-04 09:33 | Fri 2008-01-04 11:01 | 2008-01-04 11:02:30 | 2008-01-04 10:33:21 | 2008-01-04 09:33:00 | 2008-01-04 11:01:00 | 39450 days 00:01:30
Fri 2008-01-04 10:38 | Fri 2008-01-04 10:38 | Fri 2008-01-04 10:55 | 2008-01-04 10:56:47 | 2008-01-04 11:38:51 | 2008-01-04 10:38:00 | 2008-01-04 10:55:00 | 39450 days 00:01:47
Fri 2007-10-05 09:49 | Fri 2007-10-05 09:49 | Fri 2007-10-05 10:30 | 2007-10-05 10:35:11 | 2007-10-05 16:30:00 | 2007-10-05 09:49:00 | 2007-10-05 10:30:00 | 39360 days 00:05:11
Wed 2007-11-21 11:54 | Wed 2007-11-21 11:54 | Wed 2007-11-21 12:11 | 2007-11-21 12:12:40 | 2007-11-21 12:39:01 | 2007-11-21 11:54:00 | 2007-11-21 12:11:00 | 39400 days 00:01:40
Tue 2007-11-27 08:04 | Tue 2007-11-27 08:04 | Tue 2007-11-27 16:24 | 2007-11-27 16:24:57 | 2007-11-27 17:00:00 | 2007-11-27 08:04:00 | 2007-11-27 16:24:00 | 39410 days 00:00:57
Wed 2007-11-28 16:55 | Wed 2007-11-28 16:55 | Fri 2007-11-30 16:29 | 2007-11-30 16:30:51 | 2007-11-28 17:30:00 | 2007-11-28 16:55:00 | 2007-11-30 16:29:00 | 39410 days 00:01:51
Thu 2007-11-29 15:37 | Thu 2007-11-29 15:37 | Wed 2007-12-19 12:25 | 2007-12-19 12:26:59 | 2007-11-29 16:22:03 | 2007-11-29 15:37:00 | 2007-12-19 12:25:00 | 39430 days 00:01:59
Sat 2007-12-01 17:43 | Mon 2007-12-03 08:00 | Mon 2007-12-03 08:59 | 2007-12-03 09:00:13 | 2007-12-03 09:00:00 | 2007-12-03 08:00:00 | 2007-12-03 08:59:00 | 39410 days 00:01:13
Mon 2007-12-03 10:43 | Mon 2007-12-03 10:43 | Wed 2007-12-05 09:59 | 2007-12-05 09:59:44 | 2007-12-03 17:30:00 | 2007-12-03 10:43:00 | 2007-12-05 09:59:00 | 39420 days 00:00:44
Mon 2007-12-03 10:52 | Mon 2007-12-03 10:52 | Mon 2007-12-03 12:21 | 2007-12-03 12:22:23 | 2007-12-03 17:30:00 | 2007-12-03 10:52:00 | 2007-12-03 12:21:00 | 39410 days 00:01:23
Mon 2007-12-03 10:54 | Mon 2007-12-03 10:54 | Mon 2007-12-03 12:06 | 2007-12-03 12:07:15 | 2007-12-03 17:30:00 | 2007-12-03 10:54:00 | 2007-12-03 12:06:00 | 39410 days 00:01:15
Mon 2007-12-03 13:11 | Mon 2007-12-03 13:11 | Mon 2007-12-03 16:08 | 2007-12-03 16:09:21 | 2007-12-03 17:00:00 | 2007-12-03 13:11:00 | 2007-12-03 16:08:00 | 39410 days 00:01:21
Wed 2007-12-05 08:40 | Wed 2007-12-05 08:40 | Wed 2007-12-05 08:46 | 2007-12-05 08:47:06 | 2007-12-05 17:30:00 | 2007-12-05 08:40:00 | 2007-12-05 08:46:00 | 39420 days 00:01:06
Thu 2007-12-06 13:59 | Thu 2007-12-06 13:59 | Thu 2007-12-06 14:05 | 2007-12-06 14:05:57 | 2007-12-06 17:00:00 | 2007-12-06 13:59:00 | 2007-12-06 14:05:00 | 39420 days 00:00:57
Thu 2007-12-06 14:23 | Thu 2007-12-06 14:23 | Thu 2007-12-06 15:04 | 2007-12-06 15:05:15 | 2007-12-06 17:30:00 | 2007-12-06 14:23:00 | 2007-12-06 15:04:00 | 39420 days 00:01:15
Fri 2007-12-07 13:30 | Fri 2007-12-07 13:30 | Mon 2007-12-10 10:18 | 2007-12-10 10:19:49 | 2007-12-07 17:30:00 | 2007-12-07 13:30:00 | 2007-12-10 10:18:00 | 39420 days 00:01:49
Sun 2007-12-09 14:03 | Mon 2007-12-10 08:00 | Tue 2007-12-11 16:46 | 2007-12-13 10:06:23 | 2007-12-10 17:30:00 | 2007-12-10 08:00:00 | 2007-12-11 16:46:00 | 39421 days 17:20:23
Tue 2007-12-11 09:53 | Tue 2007-12-11 09:53 | Wed 2007-12-19 11:49 | 2007-12-19 11:51:45 | 2007-12-11 17:00:00 | 2007-12-11 09:53:00 | 2007-12-19 11:49:00 | 39430 days 00:02:45
Wed 2007-12-12 14:46 | Wed 2007-12-12 14:46 | Wed 2007-12-12 14:55 | 2007-12-12 14:56:02 | 2007-12-12 15:31:51 | 2007-12-12 14:46:00 | 2007-12-12 14:55:00 | 39420 days 00:01:02
Fri 2007-12-14 08:21 | Fri 2007-12-14 08:21 | Fri 2007-12-14 08:43 | 2007-12-14 08:44:46 | 2007-12-14 09:21:59 | 2007-12-14 08:21:00 | 2007-12-14 08:43:00 | 39430 days 00:01:46
Mon 2007-12-17 13:40 | Mon 2007-12-17 13:40 | Mon 2007-12-17 14:34 | 2007-12-17 14:36:56 | 2007-12-17 14:25:58 | 2007-12-17 13:40:00 | 2007-12-17 14:34:00 | 39430 days 00:02:56
Mon 2007-12-17 14:03 | Mon 2007-12-17 14:03 | Mon 2007-12-17 14:13 | 2007-12-17 14:14:28 | 2007-12-17 15:03:57 | 2007-12-17 14:03:00 | 2007-12-17 14:13:00 | 39430 days 00:01:28
Mon 2007-12-17 16:16 | Mon 2007-12-17 16:16 | Wed 2007-12-19 09:24 | 2007-12-19 09:25:44 | 2007-12-17 17:00:00 | 2007-12-17 16:16:00 | 2007-12-19 09:24:00 | 39430 days 00:01:44
Mon 2007-12-17 16:19 | Mon 2007-12-17 16:19 | Mon 2007-12-17 16:35 | 2007-12-17 16:36:53 | 2007-12-17 17:19:43 | 2007-12-17 16:19:00 | 2007-12-17 16:35:00 | 39430 days 00:01:53
Tue 2007-12-18 09:01 | Tue 2007-12-18 09:01 | Tue 2007-12-18 13:53 | 2007-12-18 13:55:17 | 2007-12-18 17:30:00 | 2007-12-18 09:01:00 | 2007-12-18 13:53:00 | 39430 days 00:02:17
Tue 2007-12-18 10:27 | Tue 2007-12-18 10:27 | Tue 2007-12-18 10:47 | 2007-12-18 10:48:10 | 2007-12-18 17:30:00 | 2007-12-18 10:27:00 | 2007-12-18 10:47:00 | 39430 days 00:01:10
Tue 2007-12-18 11:13 | Tue 2007-12-18 11:13 | Tue 2007-12-18 11:35 | 2007-12-18 11:36:00 | 2007-12-18 11:43:29 | 2007-12-18 11:13:00 | 2007-12-18 11:35:00 | 39430 days 00:01:00