Spreadsheet: 476654d1471959730-date-and-time-not-recognized-in-cells-need-a-formula-oeldere-476642d1471957523-date-and-time-not-recognized-in-cells-need-a-formula-book1
Sheet: Sheet2

text to column |  |  |  |  |  | helpcel | helpcel | Result |  |  |  | helptable
6-28-2016 1:26:00 PM | 6 | 28 | 2016 | 01:26:00 | PM |  |  |  |  |  | 1 | January
6-28-2016 1:35:00 AM | 6 | 28 | 2016 | 01:35:00 | AM |  |  |  |  |  | 2 | February
6-28-2016 1:35:00 AM | 6 | 28 | 2016 | 01:35:00 | AM |  |  |  |  |  | 3 | March
6-28-2016 10:04:00 AM | 6 | 28 | 2016 | 10:04:00 | AM |  |  |  |  |  | 4 | April
6-28-2016 12:29:00 PM | 6 | 28 | 2016 | 12:29:00 | PM |  |  |  |  |  | 5 | [NAME]
6-28-2016 12:38:00 PM | 6 | 28 | 2016 | 12:38:00 | PM |  |  |  |  |  | 6 | Juny
6-28-2016 12:38:00 PM | 6 | 28 | 2016 | 12:38:00 | PM |  |  |  |  |  | 7 | July
6-28-2016 2:54:00 AM | 6 | 28 | 2016 | 02:54:00 | AM |  |  |  |  |  | 8 | August
6-28-2016 4:07:00 PM | 6 | 28 | 2016 | 04:07:00 | PM |  |  |  |  |  | 9 | September
6-28-2016 4:56:00 PM | 6 | 28 | 2016 | 04:56:00 | PM |  |  |  |  |  | 10 | October
6-28-2016 8:00:00 AM | 6 | 28 | 2016 | 08:00:00 | AM |  |  |  |  |  | 11 | November
6-28-2016 8:38:00 AM | 6 | 28 | 2016 | 08:38:00 | AM |  |  |  |  |  | 12 | December
6-29-2016 1:17:00 AM | 6 | 29 | 2016 | 01:17:00 | AM
6-29-2016 10:20:00 AM | 6 | 29 | 2016 | 10:20:00 | AM
6-29-2016 10:30:00 AM | 6 | 29 | 2016 | 10:30:00 | AM
6-29-2016 10:30:00 AM | 6 | 29 | 2016 | 10:30:00 | AM
6-29-2016 10:40:00 PM | 6 | 29 | 2016 | 10:40:00 | PM
6-29-2016 12:27:00 PM | 6 | 29 | 2016 | 12:27:00 | PM
6-29-2016 12:29:00 AM | 6 | 29 | 2016 | 12:29:00 | AM
6-29-2016 2:58:00 PM | 6 | 29 | 2016 | 02:58:00 | PM
6-29-2016 4:05:00 PM | 6 | 29 | 2016 | 04:05:00 | PM
6-29-2016 4:13:00 PM | 6 | 29 | 2016 | 04:13:00 | PM
6-29-2016 4:15:00 AM | 6 | 29 | 2016 | 04:15:00 | AM
6-29-2016 4:24:00 PM | 6 | 29 | 2016 | 04:24:00 | PM
6-29-2016 4:39:00 PM | 6 | 29 | 2016 | 04:39:00 | PM
6-29-2016 4:40:00 PM | 6 | 29 | 2016 | 04:40:00 | PM
6-29-2016 4:51:00 PM | 6 | 29 | 2016 | 04:51:00 | PM
6-29-2016 5:06:00 PM | 6 | 29 | 2016 | 05:06:00 | PM
6-29-2016 5:26:00 PM | 6 | 29 | 2016 | 05:26:00 | PM
6-29-2016 5:26:00 PM | 6 | 29 | 2016 | 05:26:00 | PM
6-29-2016 6:40:00 AM | 6 | 29 | 2016 | 06:40:00 | AM
6-29-2016 7:00:00 AM | 6 | 29 | 2016 | 07:00:00 | AM
6-29-2016 7:09:00 PM | 6 | 29 | 2016 | 07:09:00 | PM
6-29-2016 8:22:00 AM | 6 | 29 | 2016 | 08:22:00 | AM
6-29-2016 8:54:00 AM | 6 | 29 | 2016 | 08:54:00 | AM
6-29-2016 8:55:00 PM | 6 | 29 | 2016 | 08:55:00 | PM
6-29-2016 9:06:00 PM | 6 | 29 | 2016 | 09:06:00 | PM
6-29-2016 9:06:00 PM | 6 | 29 | 2016 | 09:06:00 | PM
6-29-2016 9:33:00 PM | 6 | 29 | 2016 | 09:33:00 | PM
6-29-2016 9:33:00 PM | 6 | 29 | 2016 | 09:33:00 | PM
6-30-2016 1:15:00 PM | 6 | 30 | 2016 | 01:15:00 | PM
6-30-2016 1:16:00 AM | 6 | 30 | 2016 | 01:16:00 | AM
6-30-2016 1:18:00 PM | 6 | 30 | 2016 | 01:18:00 | PM
6-30-2016 1:41:00 PM | 6 | 30 | 2016 | 01:41:00 | PM
6-30-2016 1:53:00 PM | 6 | 30 | 2016 | 01:53:00 | PM
6-30-2016 10:19:00 PM | 6 | 30 | 2016 | 10:19:00 | PM
6-30-2016 10:36:00 AM | 6 | 30 | 2016 | 10:36:00 | AM
6-30-2016 10:43:00 AM | 6 | 30 | 2016 | 10:43:00 | AM
6-30-2016 10:52:00 AM | 6 | 30 | 2016 | 10:52:00 | AM
6-30-2016 11:17:00 PM | 6 | 30 | 2016 | 11:17:00 | PM
6-30-2016 11:59:00 AM | 6 | 30 | 2016 | 11:59:00 | AM
6-30-2016 2:01:00 PM | 6 | 30 | 2016 | 02:01:00 | PM
6-30-2016 2:22:00 AM | 6 | 30 | 2016 | 02:22:00 | AM
6-30-2016 2:28:00 AM | 6 | 30 | 2016 | 02:28:00 | AM
6-30-2016 2:57:00 PM | 6 | 30 | 2016 | 02:57:00 | PM
6-30-2016 2:57:00 PM | 6 | 30 | 2016 | 02:57:00 | PM
6-30-2016 3:18:00 AM | 6 | 30 | 2016 | 03:18:00 | AM
6-30-2016 3:21:00 AM | 6 | 30 | 2016 | 03:21:00 | AM
6-30-2016 3:36:00 PM | 6 | 30 | 2016 | 03:36:00 | PM
6-30-2016 3:36:00 PM | 6 | 30 | 2016 | 03:36:00 | PM
6-30-2016 3:37:00 PM | 6 | 30 | 2016 | 03:37:00 | PM
6-30-2016 3:47:00 AM | 6 | 30 | 2016 | 03:47:00 | AM
6-30-2016 4:15:00 AM | 6 | 30 | 2016 | 04:15:00 | AM
6-30-2016 4:50:00 AM | 6 | 30 | 2016 | 04:50:00 | AM
6-30-2016 4:56:00 AM | 6 | 30 | 2016 | 04:56:00 | AM
6-30-2016 5:02:00 PM | 6 | 30 | 2016 | 05:02:00 | PM
6-30-2016 5:02:00 PM | 6 | 30 | 2016 | 05:02:00 | PM
6-30-2016 6:42:00 AM | 6 | 30 | 2016 | 06:42:00 | AM
6-30-2016 7:11:00 AM | 6 | 30 | 2016 | 07:11:00 | AM
6-30-2016 9:20:00 PM | 6 | 30 | 2016 | 09:20:00 | PM
7-13-2016 12:34:00 AM | 7 | 13 | 2016 | 12:34:00 | AM
7-18-2016 11:15:00 AM | 7 | 18 | 2016 | 11:15:00 | AM
7-18-2016 12:18:00 AM | 7 | 18 | 2016 | 12:18:00 | AM
7-21-2016 2:44:00 PM | 7 | 21 | 2016 | 02:44:00 | PM
7-21-2016 6:55:00 PM | 7 | 21 | 2016 | 06:55:00 | PM
7-23-2016 5:32:00 PM | 7 | 23 | 2016 | 05:32:00 | PM
7-23-2016 9:05:00 PM | 7 | 23 | 2016 | 09:05:00 | PM
7-24-2016 1:34:00 AM | 7 | 24 | 2016 | 01:34:00 | AM
7-24-2016 1:34:00 AM | 7 | 24 | 2016 | 01:34:00 | AM
7-24-2016 10:20:00 PM | 7 | 24 | 2016 | 10:20:00 | PM
7-24-2016 10:51:00 PM | 7 | 24 | 2016 | 10:51:00 | PM
7-24-2016 8:03:00 AM | 7 | 24 | 2016 | 08:03:00 | AM
7-24-2016 8:03:00 AM | 7 | 24 | 2016 | 08:03:00 | AM
7-25-2016 10:11:00 AM | 7 | 25 | 2016 | 10:11:00 | AM
7-25-2016 11:51:00 PM | 7 | 25 | 2016 | 11:51:00 | PM
7-25-2016 11:51:00 PM | 7 | 25 | 2016 | 11:51:00 | PM
7-26-2016 11:18:00 PM | 7 | 26 | 2016 | 11:18:00 | PM
7-26-2016 2:00:00 AM | 7 | 26 | 2016 | 02:00:00 | AM
7-26-2016 2:07:00 PM | 7 | 26 | 2016 | 02:07:00 | PM
7-26-2016 8:16:00 PM | 7 | 26 | 2016 | 08:16:00 | PM
7-26-2016 8:25:00 PM | 7 | 26 | 2016 | 08:25:00 | PM
7-26-2016 8:28:00 PM | 7 | 26 | 2016 | 08:28:00 | PM
7-27-2016 1:00:00 PM | 7 | 27 | 2016 | 01:00:00 | PM
7-27-2016 10:11:00 AM | 7 | 27 | 2016 | 10:11:00 | AM
7-27-2016 12:03:00 PM | 7 | 27 | 2016 | 12:03:00 | PM
7-27-2016 12:27:00 PM | 7 | 27 | 2016 | 12:27:00 | PM
7-27-2016 12:33:00 AM | 7 | 27 | 2016 | 12:33:00 | AM
7-27-2016 4:49:00 PM | 7 | 27 | 2016 | 04:49:00 | PM
7-27-2016 6:07:00 AM | 7 | 27 | 2016 | 06:07:00 | AM
7-27-2016 6:07:00 AM | 7 | 27 | 2016 | 06:07:00 | AM
7-27-2016 7:25:00 AM | 7 | 27 | 2016 | 07:25:00 | AM
7-27-2016 9:22:00 AM | 7 | 27 | 2016 | 09:22:00 | AM
7-27-2016 9:29:00 AM | 7 | 27 | 2016 | 09:29:00 | AM
7-27-2016 9:46:00 PM | 7 | 27 | 2016 | 09:46:00 | PM
7-28-2016 1:49:00 PM | 7 | 28 | 2016 | 01:49:00 | PM
7-28-2016 1:49:00 PM | 7 | 28 | 2016 | 01:49:00 | PM
7-28-2016 10:47:00 AM | 7 | 28 | 2016 | 10:47:00 | AM
7-28-2016 12:31:00 PM | 7 | 28 | 2016 | 12:31:00 | PM
7-28-2016 6:31:00 AM | 7 | 28 | 2016 | 06:31:00 | AM
7-28-2016 9:30:00 PM | 7 | 28 | 2016 | 09:30:00 | PM
7-28-2016 9:36:00 AM | 7 | 28 | 2016 | 09:36:00 | AM
7-28-2016 9:36:00 AM | 7 | 28 | 2016 | 09:36:00 | AM
7-29-2016 1:15:00 AM | 7 | 29 | 2016 | 01:15:00 | AM
7-29-2016 11:02:00 PM | 7 | 29 | 2016 | 11:02:00 | PM
7-29-2016 2:20:00 PM | 7 | 29 | 2016 | 02:20:00 | PM
7-29-2016 2:30:00 AM | 7 | 29 | 2016 | 02:30:00 | AM
7-29-2016 6:14:00 PM | 7 | 29 | 2016 | 06:14:00 | PM
7-29-2016 8:23:00 PM | 7 | 29 | 2016 | 08:23:00 | PM
7-29-2016 9:35:00 PM | 7 | 29 | 2016 | 09:35:00 | PM
7-29-2016 9:39:00 PM | 7 | 29 | 2016 | 09:39:00 | PM
7-30-2016 1:13:00 AM | 7 | 30 | 2016 | 01:13:00 | AM
7-30-2016 1:59:00 PM | 7 | 30 | 2016 | 01:59:00 | PM
7-30-2016 10:41:00 AM | 7 | 30 | 2016 | 10:41:00 | AM
7-30-2016 10:56:00 AM | 7 | 30 | 2016 | 10:56:00 | AM
7-30-2016 11:46:00 PM | 7 | 30 | 2016 | 11:46:00 | PM
7-30-2016 2:45:00 PM | 7 | 30 | 2016 | 02:45:00 | PM
7-30-2016 5:01:00 AM | 7 | 30 | 2016 | 05:01:00 | AM
7-30-2016 8:42:00 AM | 7 | 30 | 2016 | 08:42:00 | AM
7-30-2016 9:26:00 AM | 7 | 30 | 2016 | 09:26:00 | AM
7-31-2016 1:45:00 PM | 7 | 31 | 2016 | 01:45:00 | PM
7-31-2016 1:51:00 AM | 7 | 31 | 2016 | 01:51:00 | AM
7-31-2016 10:42:00 AM | 7 | 31 | 2016 | 10:42:00 | AM
7-31-2016 12:24:00 PM | 7 | 31 | 2016 | 12:24:00 | PM
7-31-2016 2:16:00 AM | 7 | 31 | 2016 | 02:16:00 | AM
7-31-2016 2:18:00 PM | 7 | 31 | 2016 | 02:18:00 | PM
7-31-2016 2:22:00 PM | 7 | 31 | 2016 | 02:22:00 | PM
7-31-2016 3:30:00 PM | 7 | 31 | 2016 | 03:30:00 | PM
7-31-2016 4:42:00 PM | 7 | 31 | 2016 | 04:42:00 | PM
7-31-2016 5:05:00 AM | 7 | 31 | 2016 | 05:05:00 | AM
7-31-2016 5:18:00 AM | 7 | 31 | 2016 | 05:18:00 | AM
7-31-2016 6:25:00 AM | 7 | 31 | 2016 | 06:25:00 | AM
7-31-2016 7:10:00 AM | 7 | 31 | 2016 | 07:10:00 | AM
7-31-2016 8:03:00 AM | 7 | 31 | 2016 | 08:03:00 | AM
7-31-2016 8:03:00 AM | 7 | 31 | 2016 | 08:03:00 | AM
AdmittedDate | AdmittedDate