Spreadsheet: 234386d1368087079-error-in-date-and-time-0format-change
Sheet: Sheet1

Assigned Date (dd/mm/yy) | Start Time (hh:[NAME]: AM / PM) | Date Completed | End Time (hh:[NAME]: AM / PM) |  |  | Assigned Date (dd/mm/yy) | Start Time (hh:[NAME]: AM / PM) | Date Completed | End Time (hh:[NAME]: AM / PM)
2013-05-01 00:00:00 | 09:35:00 | 2013-05-01 00:00:00 | 10:12:00 |  |  | 2013-05-01 00:00:00 | 09:35:00 | 2013-05-01 00:00:00 | 10:12:00
2013-05-01 00:00:00 | 10:13:00 | 2013-05-01 00:00:00 | 11:06:00 |  |  | 2013-05-01 00:00:00 | 10:13:00 | 2013-05-01 00:00:00 | 11:06:00
2013-05-01 00:00:00 | 11:38:00 | 2013-05-01 00:00:00 | 12:34:00 |  |  | 2013-05-01 00:00:00 | 11:38:00 | 2013-05-01 00:00:00 | 12:34:00 |  | I see this…..in Columns A:D
2013-05-01 00:00:00 | 12:34:00 | 2013-05-01 00:00:00 | 13:14:00 |  |  | 2013-05-01 00:00:00 | 12:34:00 | 2013-05-01 00:00:00 | 13:14:00
2013-05-01 00:00:00 | 13:14:00 | 2013-05-01 00:00:00 | 14:13:00 |  |  | 2013-05-01 00:00:00 | 13:14:00 | 2013-05-01 00:00:00 | 14:13:00
2013-05-01 00:00:00 | 14:14:00 | 2013-05-01 00:00:00 | 16:16:00 |  |  | 2013-05-01 00:00:00 | 14:14:00 | 2013-05-01 00:00:00 | 16:16:00
2013-05-01 00:00:00 | 16:17:00 | 2013-05-01 00:00:00 | 16:52:00 |  |  | 2013-05-01 00:00:00 | 16:17:00 | 2013-05-01 00:00:00 | 16:52:00
2013-05-02 00:00:00 | 08:30:00 | 2013-05-02 00:00:00 | 09:00:00 |  |  | 2013-05-02 00:00:00 | 08:30:00 | 2013-05-02 00:00:00 | 09:00:00
2013-05-02 00:00:00 | 09:00:00 | 2013-05-02 00:00:00 | 09:34:00 |  |  | 2013-05-02 00:00:00 | 09:00:00 | 2013-05-02 00:00:00 | 09:34:00
2013-05-02 00:00:00 | 09:34:00 | 2013-05-02 00:00:00 | 10:05:00 |  |  | 2013-05-02 00:00:00 | 09:34:00 | 2013-05-02 00:00:00 | 10:05:00
2013-05-02 00:00:00 | 10:05:00 | 2013-05-02 00:00:00 | 10:56:00 |  |  | 2013-05-02 00:00:00 | 10:05:00 | 2013-05-02 00:00:00 | 10:56:00
2013-05-02 00:00:00 | 10:56:00 | 2013-05-02 00:00:00 | 12:38:00 |  |  | 2013-05-02 00:00:00 | 10:56:00 | 2013-05-02 00:00:00 | 12:38:00
2013-05-02 00:00:00 | 12:39:00 | 2013-05-02 00:00:00 | 13:18:00 |  |  | 2013-05-02 00:00:00 | 12:39:00 | 2013-05-02 00:00:00 | 13:18:00
2013-05-02 00:00:00 | 13:19:00 | 2013-05-02 00:00:00 | 14:10:00 |  |  | 2013-05-02 00:00:00 | 13:19:00 | 2013-05-02 00:00:00 | 14:10:00
2013-05-02 00:00:00 | 14:11:00 | 2013-05-02 00:00:00 | 14:46:00 |  |  | 2013-05-02 00:00:00 | 14:11:00 | 2013-05-02 00:00:00 | 14:46:00
2013-05-02 00:00:00 | 14:46:00 | 2013-05-02 00:00:00 | 15:45:00 |  |  | 2013-05-02 00:00:00 | 14:46:00 | 2013-05-02 00:00:00 | 15:45:00
2013-05-02 00:00:00 | 15:46:00 | 2013-05-02 00:00:00 | 16:22:00 |  |  | 2013-05-02 00:00:00 | 15:46:00 | 2013-05-02 00:00:00 | 16:22:00
2013-05-02 00:00:00 | 16:23:00 | 2013-05-08 00:00:00 | 17:00:00 |  |  | 2013-05-02 00:00:00 | 16:23:00 | 2013-05-08 00:00:00 | 17:00:00
2013-05-07 00:00:00 | 08:50:00 | 2013-05-07 00:00:00 | 10:05:00 |  |  | 2013-05-07 00:00:00 | 08:50:00 | 2013-05-07 00:00:00 | 10:05:00
2013-05-07 00:00:00 | 10:33:00 | 2013-05-07 00:00:00 | 12:17:00 |  |  | 2013-05-07 00:00:00 | 10:33:00 | 2013-05-07 00:00:00 | 12:17:00
2013-05-07 00:00:00 | 12:18:00 | 2013-05-07 00:00:00 | 12:49:00 |  |  | 2013-05-07 00:00:00 | 12:18:00 | 2013-05-07 00:00:00 | 12:49:00
2013-05-07 00:00:00 | 12:50:00 | 2013-05-07 00:00:00 | 13:51:00 |  |  | 2013-05-07 00:00:00 | 12:50:00 | 2013-05-07 00:00:00 | 13:51:00
2013-05-07 00:00:00 | 13:51:00 | 2013-05-07 00:00:00 | 14:25:00 |  |  | 2013-05-07 00:00:00 | 13:51:00 | 2013-05-07 00:00:00 | 14:25:00
2013-05-07 00:00:00 | 14:25:00 | 2013-05-07 00:00:00 | 15:01:00 |  |  | 2013-05-07 00:00:00 | 14:25:00 | 2013-05-07 00:00:00 | 15:01:00
2013-05-07 00:00:00 | 15:28:00 | 2013-05-07 00:00:00 | 15:58:00 |  |  | 2013-05-07 00:00:00 | 15:28:00 | 2013-05-07 00:00:00 | 15:58:00
2013-05-07 00:00:00 | 15:58:00 | 2013-05-07 00:00:00 | 16:24:00 |  |  | 2013-05-07 00:00:00 | 15:58:00 | 2013-05-07 00:00:00 | 16:24:00
2013-05-07 00:00:00 | 16:36:00 | 2013-05-07 00:00:00 | 16:45:00 |  |  | 2013-05-07 00:00:00 | 16:36:00 | 2013-05-07 00:00:00 | 16:45:00
2013-05-07 00:00:00 | 07:59:00 | 2013-05-08 00:00:00 | 08:25:00 |  |  | 2013-05-07 00:00:00 | 07:59:00 | 2013-05-08 00:00:00 | 08:25:00
2013-05-08 00:00:00 | 08:25:00 | 2013-05-08 00:00:00 | 09:26:00 |  |  | 2013-05-08 00:00:00 | 08:25:00 | 2013-05-08 00:00:00 | 09:26:00
2013-05-08 00:00:00 | 09:26:00 | 2013-05-08 00:00:00 | 10:03:00 |  |  | 2013-05-08 00:00:00 | 09:26:00 | 2013-05-08 00:00:00 | 10:03:00
2013-05-08 00:00:00 | 10:03:00 | 2013-05-08 00:00:00 | 10:14:00 |  |  | 2013-05-08 00:00:00 | 10:03:00 | 2013-05-08 00:00:00 | 10:14:00
2013-05-08 00:00:00 | 12:11:00 | 2013-05-08 00:00:00 | 12:49:00 |  |  | 2013-05-08 00:00:00 | 12:11:00 | 2013-05-08 00:00:00 | 12:49:00
2013-05-08 00:00:00 | 10:14:00 | 2013-05-08 00:00:00 | 10:49:00 |  |  | 2013-05-08 00:00:00 | 10:14:00 | 2013-05-08 00:00:00 | 10:49:00
2013-05-08 00:00:00 | 10:49:00 | 2013-05-08 00:00:00 | 12:09:00 |  |  | 2013-05-08 00:00:00 | 10:49:00 | 2013-05-08 00:00:00 | 12:09:00
2013-05-08 00:00:00 | 12:57:00 | 2013-05-08 00:00:00 | 13:28:00 |  |  | 2013-05-08 00:00:00 | 12:57:00 | 2013-05-08 00:00:00 | 13:28:00
2013-05-08 00:00:00 | 13:29:00 | 2013-05-08 00:00:00 | 14:04:00 |  |  | 2013-05-08 00:00:00 | 13:29:00 | 2013-05-08 00:00:00 | 14:04:00
2013-05-08 00:00:00 | 14:05:00 | 2013-05-08 00:00:00 | 14:42:00 |  |  | 2013-05-08 00:00:00 | 14:05:00 | 2013-05-08 00:00:00 | 14:42:00
2013-05-08 00:00:00 | 14:42:00 | 2013-05-08 00:00:00 | 15:46:00 |  |  | 2013-05-08 00:00:00 | 14:42:00 | 2013-05-08 00:00:00 | 15:46:00
2013-05-08 00:00:00 | 15:46:00 | 2013-05-08 00:00:00 | 16:16:00 |  |  | 2013-05-08 00:00:00 | 15:46:00 | 2013-05-08 00:00:00 | 16:16:00
2013-05-08 00:00:00 | 16:16:00 | 2013-05-08 00:00:00 | 16:53:00 |  |  | 2013-05-08 00:00:00 | 16:16:00 | 2013-05-08 00:00:00 | 16:53:00
2013-05-09 00:00:00 | 07:59:00 | 2013-05-09 00:00:00 |  |  |  | 2013-05-09 00:00:00 | 07:59:00 | 2013-05-09 00:00:00
2013-05-09 00:00:00 |  | 2013-05-09 00:00:00 |  |  |  | 2013-05-09 00:00:00 |  | 2013-05-09 00:00:00
2013-05-09 00:00:00 |  | 2013-05-09 00:00:00 |  |  |  | 2013-05-09 00:00:00 |  | 2013-05-09 00:00:00
2013-05-09 00:00:00 |  | 2013-05-09 00:00:00 |  |  |  | 2013-05-09 00:00:00 |  | 2013-05-09 00:00:00
2013-05-09 00:00:00 |  | 2013-05-09 00:00:00 |  |  |  | 2013-05-09 00:00:00 |  | 2013-05-09 00:00:00
2013-05-09 00:00:00 |  | 2013-05-09 00:00:00 |  |  |  | 2013-05-09 00:00:00 |  | 2013-05-09 00:00:00
2013-05-09 00:00:00 |  | 2013-05-09 00:00:00 |  |  |  | 2013-05-09 00:00:00 |  | 2013-05-09 00:00:00
2013-05-09 00:00:00 |  | 2013-05-09 00:00:00 |  |  |  | 2013-05-09 00:00:00 |  | 2013-05-09 00:00:00
2013-05-09 00:00:00 |  | 2013-05-09 00:00:00 |  |  |  | 2013-05-09 00:00:00 |  | 2013-05-09 00:00:00
2013-05-09 00:00:00 |  | 2013-05-09 00:00:00 |  |  |  | 2013-05-09 00:00:00 |  | 2013-05-09 00:00:00
2013-05-09 00:00:00 |  | 2013-05-09 00:00:00 |  |  |  | 2013-05-09 00:00:00 |  | 2013-05-09 00:00:00
2013-05-09 00:00:00 |  | 2013-05-09 00:00:00 |  |  |  | 2013-05-09 00:00:00 |  | 2013-05-09 00:00:00