Effacer les filtres
Effacer les filtres

Combing Date and Time Variables into ONE DateTime Vector

10 vues (au cours des 30 derniers jours)
Abigail Hobbs
Abigail Hobbs le 17 Juin 2024
Modifié(e) : Stephen23 le 18 Juin 2024
I am working with a dataset that gives me a 2 different row vectors for date and time - I want to combine these two variables (each their own row) into one datetime vector. Currently I am just creating a separate datetime vector that is correct, but it would be nice to not hard code this with each new dataset I have to import. Struggling to find a not so roundabout way to do this. Thanks!
  2 commentaires
Stephen23
Stephen23 le 17 Juin 2024
@Abigail Hobbs: please upload a sample data file by clicking the paperclip button.
Abigail Hobbs
Abigail Hobbs le 18 Juin 2024
Here is an example! I just pulled the date and duration segements from my dataset which I am talking about. Thank you!

Connectez-vous pour commenter.

Réponses (2)

Steven Lord
Steven Lord le 17 Juin 2024
So you have a datetime array and a duration array?
n = 10;
dt = datetime(2024, 6, randi(30, n, 1))
dt = 10x1 datetime array
24-Jun-2024 15-Jun-2024 15-Jun-2024 13-Jun-2024 21-Jun-2024 13-Jun-2024 12-Jun-2024 25-Jun-2024 09-Jun-2024 28-Jun-2024
du = duration(randi(24, n, 1), randi([0 59], n, 1), randi([0 59], n, 1))
du = 10x1 duration array
24:50:29 15:52:20 17:27:42 18:27:14 22:18:27 08:59:17 23:01:33 11:54:11 18:26:19 22:02:29
Just add them.
dt2 = dt + du
dt2 = 10x1 datetime array
25-Jun-2024 00:50:29 15-Jun-2024 15:52:20 15-Jun-2024 17:27:42 13-Jun-2024 18:27:14 21-Jun-2024 22:18:27 13-Jun-2024 08:59:17 12-Jun-2024 23:01:33 25-Jun-2024 11:54:11 09-Jun-2024 18:26:19 28-Jun-2024 22:02:29
You may want to tweak the Format of the resulting datetime array depending on how you want to display the information.
dt2.Format = 'dd-MMM-yyyy hh:mm:ss a' % 12 hour clock with AM/PM
dt2 = 10x1 datetime array
25-Jun-2024 12:50:29 AM 15-Jun-2024 03:52:20 PM 15-Jun-2024 05:27:42 PM 13-Jun-2024 06:27:14 PM 21-Jun-2024 10:18:27 PM 13-Jun-2024 08:59:17 AM 12-Jun-2024 11:01:33 PM 25-Jun-2024 11:54:11 AM 09-Jun-2024 06:26:19 PM 28-Jun-2024 10:02:29 PM

Stephen23
Stephen23 le 18 Juin 2024
Modifié(e) : Stephen23 le 18 Juin 2024
If you have any influence on the data design, then making these changes would simplify your data processing:
  • save the data in columns, not in rows.
  • save the dates and times as Excel dates, not as text.
C = readcell('matlab_example_data.xlsx')
C = 2x1411 cell array
Columns 1 through 11 {'Date' } {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'Start Time'} {'14:58:32'} {'14:59:32'} {'15:00:32'} {'15:01:32'} {'15:02:32'} {'15:03:32'} {'15:04:32'} {'15:05:32'} {'15:06:32'} {'15:07:32'} Columns 12 through 22 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'15:08:32'} {'15:09:32'} {'15:10:32'} {'15:11:32'} {'15:12:32'} {'15:13:32'} {'15:14:32'} {'15:15:32'} {'15:16:32'} {'15:17:32'} {'15:18:32'} Columns 23 through 33 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'15:19:32'} {'15:20:32'} {'15:21:32'} {'15:22:32'} {'15:23:32'} {'15:24:32'} {'15:25:32'} {'15:26:32'} {'15:27:32'} {'15:28:32'} {'15:29:32'} Columns 34 through 44 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'15:30:32'} {'15:31:32'} {'15:32:32'} {'15:33:32'} {'15:34:32'} {'15:35:32'} {'15:36:32'} {'15:37:32'} {'15:38:32'} {'15:39:32'} {'15:40:32'} Columns 45 through 55 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'15:41:32'} {'15:42:32'} {'15:43:32'} {'15:44:32'} {'15:45:32'} {'15:46:32'} {'15:47:32'} {'15:48:32'} {'15:49:32'} {'15:50:32'} {'15:51:32'} Columns 56 through 66 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'15:52:32'} {'15:53:32'} {'15:54:32'} {'15:55:32'} {'15:56:32'} {'15:57:32'} {'15:58:32'} {'15:59:32'} {'16:00:32'} {'16:01:32'} {'16:02:32'} Columns 67 through 77 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'16:03:32'} {'16:04:32'} {'16:05:32'} {'16:06:32'} {'16:07:32'} {'16:08:32'} {'16:09:32'} {'16:10:32'} {'16:11:32'} {'16:12:32'} {'16:13:32'} Columns 78 through 88 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'16:14:32'} {'16:15:32'} {'16:16:32'} {'16:17:32'} {'16:18:32'} {'16:19:32'} {'16:20:32'} {'16:21:32'} {'16:22:32'} {'16:23:32'} {'16:24:32'} Columns 89 through 99 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'16:25:32'} {'16:26:32'} {'16:27:32'} {'16:28:32'} {'16:29:32'} {'16:30:32'} {'16:31:32'} {'16:32:32'} {'16:33:32'} {'16:34:32'} {'16:35:32'} Columns 100 through 110 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'16:36:32'} {'16:37:32'} {'16:38:32'} {'16:39:32'} {'16:40:32'} {'16:41:32'} {'16:42:32'} {'16:43:32'} {'16:44:32'} {'16:45:32'} {'16:46:32'} Columns 111 through 121 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'16:47:32'} {'16:48:32'} {'16:49:32'} {'16:50:32'} {'16:51:32'} {'16:52:32'} {'16:53:32'} {'16:54:32'} {'16:55:32'} {'16:56:32'} {'16:57:32'} Columns 122 through 132 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'16:58:32'} {'16:59:32'} {'17:00:32'} {'17:01:32'} {'17:02:32'} {'17:03:32'} {'17:04:32'} {'17:05:32'} {'17:06:32'} {'17:07:32'} {'17:08:32'} Columns 133 through 143 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'17:09:32'} {'17:10:32'} {'17:11:32'} {'17:12:32'} {'17:13:32'} {'17:14:32'} {'17:15:32'} {'17:16:32'} {'17:17:32'} {'17:18:32'} {'17:19:32'} Columns 144 through 154 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'17:20:32'} {'17:21:32'} {'17:22:32'} {'17:23:32'} {'17:24:32'} {'17:25:32'} {'17:26:32'} {'17:27:32'} {'17:28:32'} {'17:29:32'} {'17:30:32'} Columns 155 through 165 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'17:31:32'} {'17:32:32'} {'17:33:32'} {'17:34:32'} {'17:35:32'} {'17:36:32'} {'17:37:32'} {'17:38:32'} {'17:39:32'} {'17:40:32'} {'17:41:32'} Columns 166 through 176 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'17:42:32'} {'17:43:32'} {'17:44:32'} {'17:45:32'} {'17:46:32'} {'17:47:32'} {'17:48:32'} {'17:49:32'} {'17:50:32'} {'17:51:32'} {'17:52:32'} Columns 177 through 187 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'17:53:32'} {'17:54:32'} {'17:55:32'} {'17:56:32'} {'17:57:32'} {'17:58:32'} {'17:59:32'} {'18:00:32'} {'18:01:32'} {'18:02:32'} {'18:03:32'} Columns 188 through 198 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'18:04:32'} {'18:05:32'} {'18:06:32'} {'18:07:32'} {'18:08:32'} {'18:09:32'} {'18:10:32'} {'18:11:32'} {'18:12:32'} {'18:13:32'} {'18:14:32'} Columns 199 through 209 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'18:15:32'} {'18:16:32'} {'18:17:32'} {'18:18:32'} {'18:19:32'} {'18:20:32'} {'18:21:32'} {'18:22:32'} {'18:23:32'} {'18:24:32'} {'18:25:32'} Columns 210 through 220 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'18:26:32'} {'18:27:32'} {'18:28:32'} {'18:29:32'} {'18:30:32'} {'18:31:32'} {'18:32:32'} {'18:33:32'} {'18:34:32'} {'18:35:32'} {'18:36:32'} Columns 221 through 231 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'18:37:32'} {'18:38:32'} {'18:39:32'} {'18:40:32'} {'18:41:32'} {'18:42:32'} {'18:43:32'} {'18:44:32'} {'18:45:32'} {'18:46:32'} {'18:47:32'} Columns 232 through 242 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'18:48:32'} {'18:49:32'} {'18:50:32'} {'18:51:32'} {'18:52:32'} {'18:53:32'} {'18:54:32'} {'18:55:32'} {'18:56:32'} {'18:57:32'} {'18:58:32'} Columns 243 through 253 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'18:59:32'} {'19:00:32'} {'19:01:32'} {'19:02:32'} {'19:03:32'} {'19:04:32'} {'19:05:32'} {'19:06:32'} {'19:07:32'} {'19:08:32'} {'19:09:32'} Columns 254 through 264 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'19:10:32'} {'19:11:32'} {'19:12:32'} {'19:13:32'} {'19:14:32'} {'19:15:32'} {'19:16:32'} {'19:17:32'} {'19:18:32'} {'19:19:32'} {'19:20:32'} Columns 265 through 275 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'19:21:32'} {'19:22:32'} {'19:23:32'} {'19:24:32'} {'19:25:32'} {'19:26:32'} {'19:27:32'} {'19:28:32'} {'19:29:32'} {'19:30:32'} {'19:31:32'} Columns 276 through 286 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'19:32:32'} {'19:33:32'} {'19:34:32'} {'19:35:32'} {'19:36:32'} {'19:37:32'} {'19:38:32'} {'19:39:32'} {'19:40:32'} {'19:41:32'} {'19:42:32'} Columns 287 through 297 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'19:43:32'} {'19:44:32'} {'19:45:32'} {'19:46:32'} {'19:47:32'} {'19:48:32'} {'19:49:32'} {'19:50:32'} {'19:51:32'} {'19:52:32'} {'19:53:32'} Columns 298 through 308 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'19:54:32'} {'19:55:32'} {'19:56:32'} {'19:57:32'} {'19:58:32'} {'19:59:32'} {'20:00:32'} {'20:01:32'} {'20:02:32'} {'20:03:32'} {'20:04:32'} Columns 309 through 319 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'20:05:32'} {'20:06:32'} {'20:07:32'} {'20:08:32'} {'20:09:32'} {'20:10:32'} {'20:11:32'} {'20:12:32'} {'20:13:32'} {'20:14:32'} {'20:15:32'} Columns 320 through 330 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'20:16:32'} {'20:17:32'} {'20:18:32'} {'20:19:32'} {'20:20:32'} {'20:21:32'} {'20:22:32'} {'20:23:32'} {'20:24:32'} {'20:25:32'} {'20:26:32'} Columns 331 through 341 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'20:27:32'} {'20:28:32'} {'20:29:32'} {'20:30:32'} {'20:31:32'} {'20:32:32'} {'20:33:32'} {'20:34:32'} {'20:35:32'} {'20:36:32'} {'20:37:32'} Columns 342 through 352 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'20:38:32'} {'20:39:32'} {'20:40:32'} {'20:41:32'} {'20:42:32'} {'20:43:32'} {'20:44:32'} {'20:45:32'} {'20:46:32'} {'20:47:32'} {'20:48:32'} Columns 353 through 363 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'20:49:32'} {'20:50:32'} {'20:51:32'} {'20:52:32'} {'20:53:32'} {'20:54:32'} {'20:55:32'} {'20:56:32'} {'20:57:32'} {'20:58:32'} {'20:59:32'} Columns 364 through 374 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'21:00:32'} {'21:01:32'} {'21:02:32'} {'21:03:32'} {'21:04:32'} {'21:05:32'} {'21:06:32'} {'21:07:32'} {'21:08:32'} {'21:09:32'} {'21:10:32'} Columns 375 through 385 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'21:11:32'} {'21:12:32'} {'21:13:32'} {'21:14:32'} {'21:15:32'} {'21:16:32'} {'21:17:32'} {'21:18:32'} {'21:19:32'} {'21:20:32'} {'21:21:32'} Columns 386 through 396 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'21:22:32'} {'21:23:32'} {'21:24:32'} {'21:25:32'} {'21:26:32'} {'21:27:32'} {'21:28:32'} {'21:29:32'} {'21:30:32'} {'21:31:32'} {'21:32:32'} Columns 397 through 407 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'21:33:32'} {'21:34:32'} {'21:35:32'} {'21:36:32'} {'21:37:32'} {'21:38:32'} {'21:39:32'} {'21:40:32'} {'21:41:32'} {'21:42:32'} {'21:43:32'} Columns 408 through 418 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'21:44:32'} {'21:45:32'} {'21:46:32'} {'21:47:32'} {'21:48:32'} {'21:49:32'} {'21:50:32'} {'21:51:32'} {'21:52:32'} {'21:53:32'} {'21:54:32'} Columns 419 through 429 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'21:55:32'} {'21:56:32'} {'21:57:32'} {'21:58:32'} {'21:59:32'} {'22:00:32'} {'22:01:32'} {'22:02:32'} {'22:03:32'} {'22:04:32'} {'22:05:32'} Columns 430 through 440 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'22:06:32'} {'22:07:32'} {'22:08:32'} {'22:09:32'} {'22:10:32'} {'22:11:32'} {'22:12:32'} {'22:13:32'} {'22:14:32'} {'22:15:32'} {'22:16:32'} Columns 441 through 451 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'22:17:32'} {'22:18:32'} {'22:19:32'} {'22:20:32'} {'22:21:32'} {'22:22:32'} {'22:23:32'} {'22:24:32'} {'22:25:32'} {'22:26:32'} {'22:27:32'} Columns 452 through 462 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'22:28:32'} {'22:29:32'} {'22:30:32'} {'22:31:32'} {'22:32:32'} {'22:33:32'} {'22:34:32'} {'22:35:32'} {'22:36:32'} {'22:37:32'} {'22:38:32'} Columns 463 through 473 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'22:39:32'} {'22:40:32'} {'22:41:32'} {'22:42:32'} {'22:43:32'} {'22:44:32'} {'22:45:32'} {'22:46:32'} {'22:47:32'} {'22:48:32'} {'22:49:32'} Columns 474 through 484 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'22:50:32'} {'22:51:32'} {'22:52:32'} {'22:53:32'} {'22:54:32'} {'22:55:32'} {'22:56:32'} {'22:57:32'} {'22:58:32'} {'22:59:32'} {'23:00:32'} Columns 485 through 495 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'23:01:32'} {'23:02:32'} {'23:03:32'} {'23:04:32'} {'23:05:32'} {'23:06:32'} {'23:07:32'} {'23:08:32'} {'23:09:32'} {'23:10:32'} {'23:11:32'} Columns 496 through 506 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'23:12:32'} {'23:13:32'} {'23:14:32'} {'23:15:32'} {'23:16:32'} {'23:17:32'} {'23:18:32'} {'23:19:32'} {'23:20:32'} {'23:21:32'} {'23:22:32'} Columns 507 through 517 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'23:23:32'} {'23:24:32'} {'23:25:32'} {'23:26:32'} {'23:27:32'} {'23:28:32'} {'23:29:32'} {'23:30:32'} {'23:31:32'} {'23:32:32'} {'23:33:32'} Columns 518 through 528 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'23:34:32'} {'23:35:32'} {'23:36:32'} {'23:37:32'} {'23:38:32'} {'23:39:32'} {'23:40:32'} {'23:41:32'} {'23:42:32'} {'23:43:32'} {'23:44:32'} Columns 529 through 539 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'23:45:32'} {'23:46:32'} {'23:47:32'} {'23:48:32'} {'23:49:32'} {'23:50:32'} {'23:51:32'} {'23:52:32'} {'23:53:32'} {'23:54:32'} {'23:55:32'} Columns 540 through 550 {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/12/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'23:56:32'} {'23:57:32'} {'23:58:32'} {'23:59:32'} {'00:00:32'} {'00:01:32'} {'00:02:32'} {'00:03:32'} {'00:04:32'} {'00:05:32'} {'00:06:32'} Columns 551 through 561 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'00:07:32'} {'00:08:32'} {'00:09:32'} {'00:10:32'} {'00:11:32'} {'00:12:32'} {'00:13:32'} {'00:14:32'} {'00:15:32'} {'00:16:32'} {'00:17:32'} Columns 562 through 572 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'00:18:32'} {'00:19:32'} {'00:20:32'} {'00:21:32'} {'00:22:32'} {'00:23:32'} {'00:24:32'} {'00:25:32'} {'00:26:32'} {'00:27:32'} {'00:28:32'} Columns 573 through 583 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'00:29:32'} {'00:30:32'} {'00:31:32'} {'00:32:32'} {'00:33:32'} {'00:34:32'} {'00:35:32'} {'00:36:32'} {'00:37:32'} {'00:38:32'} {'00:39:32'} Columns 584 through 594 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'00:40:32'} {'00:41:32'} {'00:42:32'} {'00:43:32'} {'00:44:32'} {'00:45:32'} {'00:46:32'} {'00:47:32'} {'00:48:32'} {'00:49:32'} {'00:50:32'} Columns 595 through 605 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'00:51:32'} {'00:52:32'} {'00:53:32'} {'00:54:32'} {'00:55:32'} {'00:56:32'} {'00:57:32'} {'00:58:32'} {'00:59:32'} {'01:00:32'} {'01:01:32'} Columns 606 through 616 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'01:02:32'} {'01:03:32'} {'01:04:32'} {'01:05:32'} {'01:06:32'} {'01:07:32'} {'01:08:32'} {'01:09:32'} {'01:10:32'} {'01:11:32'} {'01:12:32'} Columns 617 through 627 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'01:13:32'} {'01:14:32'} {'01:15:32'} {'01:16:32'} {'01:17:32'} {'01:18:32'} {'01:19:32'} {'01:20:32'} {'01:21:32'} {'01:22:32'} {'01:23:32'} Columns 628 through 638 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'01:24:32'} {'01:25:32'} {'01:26:32'} {'01:27:32'} {'01:28:32'} {'01:29:32'} {'01:30:32'} {'01:31:32'} {'01:32:32'} {'01:33:32'} {'01:34:32'} Columns 639 through 649 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'01:35:32'} {'01:36:32'} {'01:37:32'} {'01:38:32'} {'01:39:32'} {'01:40:32'} {'01:41:32'} {'01:42:32'} {'01:43:32'} {'01:44:32'} {'01:45:32'} Columns 650 through 660 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'01:46:32'} {'01:47:32'} {'01:48:32'} {'01:49:32'} {'01:50:32'} {'01:51:32'} {'01:52:32'} {'01:53:32'} {'01:54:32'} {'01:55:32'} {'01:56:32'} Columns 661 through 671 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'01:57:32'} {'01:58:32'} {'01:59:32'} {'02:00:32'} {'02:01:32'} {'02:02:32'} {'02:03:32'} {'02:04:32'} {'02:05:32'} {'02:06:32'} {'02:07:32'} Columns 672 through 682 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'02:08:32'} {'02:09:32'} {'02:10:32'} {'02:11:32'} {'02:12:32'} {'02:13:32'} {'02:14:32'} {'02:15:32'} {'02:16:32'} {'02:17:32'} {'02:18:32'} Columns 683 through 693 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'02:19:32'} {'02:20:32'} {'02:21:32'} {'02:22:32'} {'02:23:32'} {'02:24:32'} {'02:25:32'} {'02:26:32'} {'02:27:32'} {'02:28:32'} {'02:29:32'} Columns 694 through 704 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'02:30:32'} {'02:31:32'} {'02:32:32'} {'02:33:32'} {'02:34:32'} {'02:35:32'} {'02:36:32'} {'02:37:32'} {'02:38:32'} {'02:39:32'} {'02:40:32'} Columns 705 through 715 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'02:41:32'} {'02:42:32'} {'02:43:32'} {'02:44:32'} {'02:45:32'} {'02:46:32'} {'02:47:32'} {'02:48:32'} {'02:49:32'} {'02:50:32'} {'02:51:32'} Columns 716 through 726 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'02:52:32'} {'02:53:32'} {'02:54:32'} {'02:55:32'} {'02:56:32'} {'02:57:32'} {'02:58:32'} {'02:59:32'} {'03:00:32'} {'03:01:32'} {'03:02:32'} Columns 727 through 737 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'03:03:32'} {'03:04:32'} {'03:05:32'} {'03:06:32'} {'03:07:32'} {'03:08:32'} {'03:09:32'} {'03:10:32'} {'03:11:32'} {'03:12:32'} {'03:13:32'} Columns 738 through 748 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'03:14:32'} {'03:15:32'} {'03:16:32'} {'03:17:32'} {'03:18:32'} {'03:19:32'} {'03:20:32'} {'03:21:32'} {'03:22:32'} {'03:23:32'} {'03:24:32'} Columns 749 through 759 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'03:25:32'} {'03:26:32'} {'03:27:32'} {'03:28:32'} {'03:29:32'} {'03:30:32'} {'03:31:32'} {'03:32:32'} {'03:33:32'} {'03:34:32'} {'03:35:32'} Columns 760 through 770 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'03:36:32'} {'03:37:32'} {'03:38:32'} {'03:39:32'} {'03:40:32'} {'03:41:32'} {'03:42:32'} {'03:43:32'} {'03:44:32'} {'03:45:32'} {'03:46:32'} Columns 771 through 781 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'03:47:32'} {'03:48:32'} {'03:49:32'} {'03:50:32'} {'03:51:32'} {'03:52:32'} {'03:53:32'} {'03:54:32'} {'03:55:32'} {'03:56:32'} {'03:57:32'} Columns 782 through 792 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'03:58:32'} {'03:59:32'} {'04:00:32'} {'04:01:32'} {'04:02:32'} {'04:03:32'} {'04:04:32'} {'04:05:32'} {'04:06:32'} {'04:07:32'} {'04:08:32'} Columns 793 through 803 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'04:09:32'} {'04:10:32'} {'04:11:32'} {'04:12:32'} {'04:13:32'} {'04:14:32'} {'04:15:32'} {'04:16:32'} {'04:17:32'} {'04:18:32'} {'04:19:32'} Columns 804 through 814 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'04:20:32'} {'04:21:32'} {'04:22:32'} {'04:23:32'} {'04:24:32'} {'04:25:32'} {'04:26:32'} {'04:27:32'} {'04:28:32'} {'04:29:32'} {'04:30:32'} Columns 815 through 825 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'04:31:32'} {'04:32:32'} {'04:33:32'} {'04:34:32'} {'04:35:32'} {'04:36:32'} {'04:37:32'} {'04:38:32'} {'04:39:32'} {'04:40:32'} {'04:41:32'} Columns 826 through 836 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'04:42:32'} {'04:43:32'} {'04:44:32'} {'04:45:32'} {'04:46:32'} {'04:47:32'} {'04:48:32'} {'04:49:32'} {'04:50:32'} {'04:51:32'} {'04:52:32'} Columns 837 through 847 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'04:53:32'} {'04:54:32'} {'04:55:32'} {'04:56:32'} {'04:57:32'} {'04:58:32'} {'04:59:32'} {'05:00:32'} {'05:01:32'} {'05:02:32'} {'05:03:32'} Columns 848 through 858 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'05:04:32'} {'05:05:32'} {'05:06:32'} {'05:07:32'} {'05:08:32'} {'05:09:32'} {'05:10:32'} {'05:11:32'} {'05:12:32'} {'05:13:32'} {'05:14:32'} Columns 859 through 869 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'05:15:32'} {'05:16:32'} {'05:17:32'} {'05:18:32'} {'05:19:32'} {'05:20:32'} {'05:21:32'} {'05:22:32'} {'05:23:32'} {'05:24:32'} {'05:25:32'} Columns 870 through 880 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'05:26:32'} {'05:27:32'} {'05:28:32'} {'05:29:32'} {'05:30:32'} {'05:31:32'} {'05:32:32'} {'05:33:32'} {'05:34:32'} {'05:35:32'} {'05:36:32'} Columns 881 through 891 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'05:37:32'} {'05:38:32'} {'05:39:32'} {'05:40:32'} {'05:41:32'} {'05:42:32'} {'05:43:32'} {'05:44:32'} {'05:45:32'} {'05:46:32'} {'05:47:32'} Columns 892 through 902 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'05:48:32'} {'05:49:32'} {'05:50:32'} {'05:51:32'} {'05:52:32'} {'05:53:32'} {'05:54:32'} {'05:55:32'} {'05:56:32'} {'05:57:32'} {'05:58:32'} Columns 903 through 913 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'05:59:32'} {'06:00:32'} {'06:01:32'} {'06:02:32'} {'06:03:32'} {'06:04:32'} {'06:05:32'} {'06:06:32'} {'06:07:32'} {'06:08:32'} {'06:09:32'} Columns 914 through 924 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06:10:32'} {'06:11:32'} {'06:12:32'} {'06:13:32'} {'06:14:32'} {'06:15:32'} {'06:16:32'} {'06:17:32'} {'06:18:32'} {'06:19:32'} {'06:20:32'} Columns 925 through 935 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06:21:32'} {'06:22:32'} {'06:23:32'} {'06:24:32'} {'06:25:32'} {'06:26:32'} {'06:27:32'} {'06:28:32'} {'06:29:32'} {'06:30:32'} {'06:31:32'} Columns 936 through 946 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06:32:32'} {'06:33:32'} {'06:34:32'} {'06:35:32'} {'06:36:32'} {'06:37:32'} {'06:38:32'} {'06:39:32'} {'06:40:32'} {'06:41:32'} {'06:42:32'} Columns 947 through 957 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06:43:32'} {'06:44:32'} {'06:45:32'} {'06:46:32'} {'06:47:32'} {'06:48:32'} {'06:49:32'} {'06:50:32'} {'06:51:32'} {'06:52:32'} {'06:53:32'} Columns 958 through 968 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06:54:32'} {'06:55:32'} {'06:56:32'} {'06:57:32'} {'06:58:32'} {'06:59:32'} {'07:00:32'} {'07:01:32'} {'07:02:32'} {'07:03:32'} {'07:04:32'} Columns 969 through 979 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'07:05:32'} {'07:06:32'} {'07:07:32'} {'07:08:32'} {'07:09:32'} {'07:10:32'} {'07:11:32'} {'07:12:32'} {'07:13:32'} {'07:14:32'} {'07:15:32'} Columns 980 through 990 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'07:16:32'} {'07:17:32'} {'07:18:32'} {'07:19:32'} {'07:20:32'} {'07:21:32'} {'07:22:32'} {'07:23:32'} {'07:24:32'} {'07:25:32'} {'07:26:32'} Columns 991 through 1001 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'07:27:32'} {'07:28:32'} {'07:29:32'} {'07:30:32'} {'07:31:32'} {'07:32:32'} {'07:33:32'} {'07:34:32'} {'07:35:32'} {'07:36:32'} {'07:37:32'} Columns 1002 through 1012 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'07:38:32'} {'07:39:32'} {'07:40:32'} {'07:41:32'} {'07:42:32'} {'07:43:32'} {'07:44:32'} {'07:45:32'} {'07:46:32'} {'07:47:32'} {'07:48:32'} Columns 1013 through 1023 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'07:49:32'} {'07:50:32'} {'07:51:32'} {'07:52:32'} {'07:53:32'} {'07:54:32'} {'07:55:32'} {'07:56:32'} {'07:57:32'} {'07:58:32'} {'07:59:32'} Columns 1024 through 1034 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'08:00:32'} {'08:01:32'} {'08:02:32'} {'08:03:32'} {'08:04:32'} {'08:05:32'} {'08:06:32'} {'08:07:32'} {'08:08:32'} {'08:09:32'} {'08:10:32'} Columns 1035 through 1045 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'08:11:32'} {'08:12:32'} {'08:13:32'} {'08:14:32'} {'08:15:32'} {'08:16:32'} {'08:17:32'} {'08:18:32'} {'08:19:32'} {'08:20:32'} {'08:21:32'} Columns 1046 through 1056 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'08:22:32'} {'08:23:32'} {'08:24:32'} {'08:25:32'} {'08:26:32'} {'08:27:32'} {'08:28:32'} {'08:29:32'} {'08:30:32'} {'08:31:32'} {'08:32:32'} Columns 1057 through 1067 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'08:33:32'} {'08:34:32'} {'08:35:32'} {'08:36:32'} {'08:37:32'} {'08:38:32'} {'08:39:32'} {'08:40:32'} {'08:41:32'} {'08:42:32'} {'08:43:32'} Columns 1068 through 1078 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'08:44:32'} {'08:45:32'} {'08:46:32'} {'08:47:32'} {'08:48:32'} {'08:49:32'} {'08:50:32'} {'08:51:32'} {'08:52:32'} {'08:53:32'} {'08:54:32'} Columns 1079 through 1089 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'08:55:32'} {'08:56:32'} {'08:57:32'} {'08:58:32'} {'08:59:32'} {'09:00:32'} {'09:01:32'} {'09:02:32'} {'09:03:32'} {'09:04:32'} {'09:05:32'} Columns 1090 through 1100 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'09:06:32'} {'09:07:32'} {'09:08:32'} {'09:09:32'} {'09:10:32'} {'09:11:32'} {'09:12:32'} {'09:13:32'} {'09:14:32'} {'09:15:32'} {'09:16:32'} Columns 1101 through 1111 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'09:17:32'} {'09:18:32'} {'09:19:32'} {'09:20:32'} {'09:21:32'} {'09:22:32'} {'09:23:32'} {'09:24:32'} {'09:25:32'} {'09:26:32'} {'09:27:32'} Columns 1112 through 1122 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'09:28:32'} {'09:29:32'} {'09:30:32'} {'09:31:32'} {'09:32:32'} {'09:33:32'} {'09:34:32'} {'09:35:32'} {'09:36:32'} {'09:37:32'} {'09:38:32'} Columns 1123 through 1133 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'09:39:32'} {'09:40:32'} {'09:41:32'} {'09:42:32'} {'09:43:32'} {'09:44:32'} {'09:45:32'} {'09:46:32'} {'09:47:32'} {'09:48:32'} {'09:49:32'} Columns 1134 through 1144 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'09:50:32'} {'09:51:32'} {'09:52:32'} {'09:53:32'} {'09:54:32'} {'09:55:32'} {'09:56:32'} {'09:57:32'} {'09:58:32'} {'09:59:32'} {'10:00:32'} Columns 1145 through 1155 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'10:01:32'} {'10:02:32'} {'10:03:32'} {'10:04:32'} {'10:05:32'} {'10:06:32'} {'10:07:32'} {'10:08:32'} {'10:09:32'} {'10:10:32'} {'10:11:32'} Columns 1156 through 1166 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'10:12:32'} {'10:13:32'} {'10:14:32'} {'10:15:32'} {'10:16:32'} {'10:17:32'} {'10:18:32'} {'10:19:32'} {'10:20:32'} {'10:21:32'} {'10:22:32'} Columns 1167 through 1177 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'10:23:32'} {'10:24:32'} {'10:25:32'} {'10:26:32'} {'10:27:32'} {'10:28:32'} {'10:29:32'} {'10:30:32'} {'10:31:32'} {'10:32:32'} {'10:33:32'} Columns 1178 through 1188 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'10:34:32'} {'10:35:32'} {'10:36:32'} {'10:37:32'} {'10:38:32'} {'10:39:32'} {'10:40:32'} {'10:41:32'} {'10:42:32'} {'10:43:32'} {'10:44:32'} Columns 1189 through 1199 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'10:45:32'} {'10:46:32'} {'10:47:32'} {'10:48:32'} {'10:49:32'} {'10:50:32'} {'10:51:32'} {'10:52:32'} {'10:53:32'} {'10:54:32'} {'10:55:32'} Columns 1200 through 1210 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'10:56:32'} {'10:57:32'} {'10:58:32'} {'10:59:32'} {'11:00:32'} {'11:01:32'} {'11:02:32'} {'11:03:32'} {'11:04:32'} {'11:05:32'} {'11:06:32'} Columns 1211 through 1221 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'11:07:32'} {'11:08:32'} {'11:09:32'} {'11:10:32'} {'11:11:32'} {'11:12:32'} {'11:13:32'} {'11:14:32'} {'11:15:32'} {'11:16:32'} {'11:17:32'} Columns 1222 through 1232 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'11:18:32'} {'11:19:32'} {'11:20:32'} {'11:21:32'} {'11:22:32'} {'11:23:32'} {'11:24:32'} {'11:25:32'} {'11:26:32'} {'11:27:32'} {'11:28:32'} Columns 1233 through 1243 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'11:29:32'} {'11:30:32'} {'11:31:32'} {'11:32:32'} {'11:33:32'} {'11:34:32'} {'11:35:32'} {'11:36:32'} {'11:37:32'} {'11:38:32'} {'11:39:32'} Columns 1244 through 1254 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'11:40:32'} {'11:41:32'} {'11:42:32'} {'11:43:32'} {'11:44:32'} {'11:45:32'} {'11:46:32'} {'11:47:32'} {'11:48:32'} {'11:49:32'} {'11:50:32'} Columns 1255 through 1265 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'11:51:32'} {'11:52:32'} {'11:53:32'} {'11:54:32'} {'11:55:32'} {'11:56:32'} {'11:57:32'} {'11:58:32'} {'11:59:32'} {'12:00:32'} {'12:01:32'} Columns 1266 through 1276 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'12:02:32'} {'12:03:32'} {'12:04:32'} {'12:05:32'} {'12:06:32'} {'12:07:32'} {'12:08:32'} {'12:09:32'} {'12:10:32'} {'12:11:32'} {'12:12:32'} Columns 1277 through 1287 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'12:13:32'} {'12:14:32'} {'12:15:32'} {'12:16:32'} {'12:17:32'} {'12:18:32'} {'12:19:32'} {'12:20:32'} {'12:21:32'} {'12:22:32'} {'12:23:32'} Columns 1288 through 1298 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'12:24:32'} {'12:25:32'} {'12:26:32'} {'12:27:32'} {'12:28:32'} {'12:29:32'} {'12:30:32'} {'12:31:32'} {'12:32:32'} {'12:33:32'} {'12:34:32'} Columns 1299 through 1309 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'12:35:32'} {'12:36:32'} {'12:37:32'} {'12:38:32'} {'12:39:32'} {'12:40:32'} {'12:41:32'} {'12:42:32'} {'12:43:32'} {'12:44:32'} {'12:45:32'} Columns 1310 through 1320 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'12:46:32'} {'12:47:32'} {'12:48:32'} {'12:49:32'} {'12:50:32'} {'12:51:32'} {'12:52:32'} {'12:53:32'} {'12:54:32'} {'12:55:32'} {'12:56:32'} Columns 1321 through 1331 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'12:57:32'} {'12:58:32'} {'12:59:32'} {'13:00:32'} {'13:01:32'} {'13:02:32'} {'13:03:32'} {'13:04:32'} {'13:05:32'} {'13:06:32'} {'13:07:32'} Columns 1332 through 1342 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'13:08:32'} {'13:09:32'} {'13:10:32'} {'13:11:32'} {'13:12:32'} {'13:13:32'} {'13:14:32'} {'13:15:32'} {'13:16:32'} {'13:17:32'} {'13:18:32'} Columns 1343 through 1353 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'13:19:32'} {'13:20:32'} {'13:21:32'} {'13:22:32'} {'13:23:32'} {'13:24:32'} {'13:25:32'} {'13:26:32'} {'13:27:32'} {'13:28:32'} {'13:29:32'} Columns 1354 through 1364 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'13:30:32'} {'13:31:32'} {'13:32:32'} {'13:33:32'} {'13:34:32'} {'13:35:32'} {'13:36:32'} {'13:37:32'} {'13:38:32'} {'13:39:32'} {'13:40:32'} Columns 1365 through 1375 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'13:41:32'} {'13:42:32'} {'13:43:32'} {'13:44:32'} {'13:45:32'} {'13:46:32'} {'13:47:32'} {'13:48:32'} {'13:49:32'} {'13:50:32'} {'13:51:32'} Columns 1376 through 1386 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'13:52:32'} {'13:53:32'} {'13:54:32'} {'13:55:32'} {'13:56:32'} {'13:57:32'} {'13:58:32'} {'13:59:32'} {'14:00:32'} {'14:01:32'} {'14:02:32'} Columns 1387 through 1397 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'14:03:32'} {'14:04:32'} {'14:05:32'} {'14:06:32'} {'14:07:32'} {'14:08:32'} {'14:09:32'} {'14:10:32'} {'14:11:32'} {'14:12:32'} {'14:13:32'} Columns 1398 through 1408 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'06/13/24'} {'14:14:32'} {'14:15:32'} {'14:16:32'} {'14:17:32'} {'14:18:32'} {'14:19:32'} {'14:20:32'} {'14:21:32'} {'14:22:32'} {'14:23:32'} {'14:24:32'} Columns 1409 through 1411 {'06/13/24'} {'06/13/24'} {'06/13/24'} {'14:25:32'} {'14:26:32'} {'14:27:32'}
D = datetime(C(1,2:end), 'InputFormat','d/M/yy', 'Format','yyyy/MM/dd HH:mm:ss') + ...
duration(C(2,2:end), 'InputFormat','hh:mm:ss');
D = D(:)
D = 1410x1 datetime array
2024/12/06 14:58:32 2024/12/06 14:59:32 2024/12/06 15:00:32 2024/12/06 15:01:32 2024/12/06 15:02:32 2024/12/06 15:03:32 2024/12/06 15:04:32 2024/12/06 15:05:32 2024/12/06 15:06:32 2024/12/06 15:07:32 2024/12/06 15:08:32 2024/12/06 15:09:32 2024/12/06 15:10:32 2024/12/06 15:11:32 2024/12/06 15:12:32 2024/12/06 15:13:32 2024/12/06 15:14:32 2024/12/06 15:15:32 2024/12/06 15:16:32 2024/12/06 15:17:32 2024/12/06 15:18:32 2024/12/06 15:19:32 2024/12/06 15:20:32 2024/12/06 15:21:32 2024/12/06 15:22:32 2024/12/06 15:23:32 2024/12/06 15:24:32 2024/12/06 15:25:32 2024/12/06 15:26:32 2024/12/06 15:27:32

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by