現在この質問をフォロー中です
- フォローしているコンテンツ フィードに更新が表示されます。
- コミュニケーション基本設定に応じて電子メールを受け取ることができます。
Combing Date and Time Variables into ONE DateTime Vector
10 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
Abigail Hobbs
2024 年 6 月 18 日
Here is an example! I just pulled the date and duration segements from my dataset which I am talking about. Thank you!
回答 (2 件)
Steven Lord
2024 年 6 月 17 日
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
2024 年 6 月 18 日
編集済み: Stephen23
2024 年 6 月 18 日
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 
Web サイトの選択
Web サイトを選択すると、翻訳されたコンテンツにアクセスし、地域のイベントやサービスを確認できます。現在の位置情報に基づき、次のサイトの選択を推奨します:
また、以下のリストから Web サイトを選択することもできます。
最適なサイトパフォーマンスの取得方法
中国のサイト (中国語または英語) を選択することで、最適なサイトパフォーマンスが得られます。その他の国の MathWorks のサイトは、お客様の地域からのアクセスが最適化されていません。
南北アメリカ
- América Latina (Español)
- Canada (English)
- United States (English)
ヨーロッパ
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom (English)
アジア太平洋地域
- Australia (English)
- India (English)
- New Zealand (English)
- 中国
- 日本Japanese (日本語)
- 한국Korean (한국어)