Fill in the missing time stamps in measurment data when the system is runnign but not when the system was OFF

4 次查看（过去 30 天）
Sachin Hegde
Sachin Hegde 2024-7-16
评论： Sachin Hegde 2024-7-16
Hello everyone,
I have 3 measurements in 3 excel sheets, each having two columns : Time stamp, State
The data is more or less continuously recorded (with different time resolution in 3 sheets) when the system was running and is discontinuous when the system was OFF.
What i want is for all the time stamps to match each other so that i can do my analysis.
I tried to import it in Matlab, and match the time stamps. I got some results by making the whole data continuous (i.e. filling in the missing time stamps). However this is not what i want as i would like to keep the discontinuity when the system was OFF so that the histogram data doesnt count unnecessary information.
I have attached a portion of the 3 excel sheets for example (In the raw data the discontinuity also happens for DAY as the system was turned OFF at night).
As one can see Data1.xlsx has the best time resolution and i would like if Data2 and Data3 could also match this time by filling in the missing points. However one can also see that there is a huge discontinuity between 12:53 and 14:01 which i would like to keep that way.
I kindly request someone to help me with this problem.

请先登录，再回答此问题。

采纳的回答

Voss
Voss 2024-7-16
Ran in:
Data1 = readtimetable('Data1.xlsx');
Data2 = readtimetable('Data2.xlsx');
Data3 = readtimetable('Data3.xlsx');
Maybe one of the following approaches using synchronize will work for what you want to do. The difference is how the missing State values are filled in.
1. Use NaNs for missing State values:
AllData = synchronize(Data1,Data2,Data3,Data1.Time);
disp(AllData)
Time State_Data1 State_Data2 State_Data3 ____________________ ___________ ___________ ___________ 07-Aug-2023 12:52:00 0 0 0.8125 07-Aug-2023 12:52:01 0 0 0.8125 07-Aug-2023 12:52:02 0 NaN 0.8125 07-Aug-2023 12:52:03 0 NaN 0.8125 07-Aug-2023 12:52:04 0 NaN 0.8125 07-Aug-2023 12:52:05 0 NaN 0.8125 07-Aug-2023 12:52:06 0 NaN 0.8125 07-Aug-2023 12:52:07 0 NaN 0.8125 07-Aug-2023 12:52:08 0 NaN 0.8125 07-Aug-2023 12:52:09 0 NaN 0.8125 07-Aug-2023 12:52:10 0 NaN 0.8125 07-Aug-2023 12:52:11 0 NaN 0.8125 07-Aug-2023 12:52:12 0 NaN 0.8125 07-Aug-2023 12:52:13 0 NaN 0.8125 07-Aug-2023 12:52:14 0 NaN 0.8125 07-Aug-2023 12:52:15 0 NaN 0.8125 07-Aug-2023 12:52:16 0 NaN 0.8125 07-Aug-2023 12:52:17 0 NaN 0.8125 07-Aug-2023 12:52:18 0 NaN 0.8125 07-Aug-2023 12:52:19 0 NaN 0.8125 07-Aug-2023 12:52:20 0 NaN 0.8125 07-Aug-2023 12:52:21 0 NaN 0.8125 07-Aug-2023 12:52:22 0 NaN 0.8125 07-Aug-2023 12:52:23 0 NaN 0.8125 07-Aug-2023 12:52:24 0 NaN 0.8125 07-Aug-2023 12:52:25 0 NaN 0.8125 07-Aug-2023 12:52:26 0 NaN 0.8125 07-Aug-2023 12:52:27 0 NaN 0.8125 07-Aug-2023 12:52:28 0 NaN 0.8125 07-Aug-2023 12:52:29 0 NaN 0.8125 07-Aug-2023 12:52:30 0 NaN 0.8125 07-Aug-2023 12:52:31 0 NaN 0.8125 07-Aug-2023 12:52:32 0 NaN 0.8125 07-Aug-2023 12:52:33 0 NaN 0.8125 07-Aug-2023 12:52:34 0 NaN 0.8125 07-Aug-2023 12:52:35 0 NaN 0.8125 07-Aug-2023 12:52:36 0 NaN 0.8125 07-Aug-2023 12:52:37 0 NaN 0.8125 07-Aug-2023 12:52:38 0 NaN 0.8125 07-Aug-2023 12:52:39 0 NaN 0.8125 07-Aug-2023 12:52:40 0 NaN 0.8125 07-Aug-2023 12:52:41 0 NaN 0.8125 07-Aug-2023 12:52:42 0 NaN 0.8125 07-Aug-2023 12:52:43 0 NaN 0.8125 07-Aug-2023 12:52:44 0 NaN 0.8125 07-Aug-2023 12:52:45 0 NaN 0.8125 07-Aug-2023 12:52:46 0 NaN 0.8125 07-Aug-2023 12:52:47 0 NaN 0.8125 07-Aug-2023 12:52:48 0 NaN 0.8125 07-Aug-2023 12:52:49 0 NaN 0.8125 07-Aug-2023 12:52:50 0 NaN 0.8125 07-Aug-2023 12:52:51 0 NaN 0.8125 07-Aug-2023 12:52:52 0 NaN 0.8125 07-Aug-2023 12:52:53 0 NaN 0.8125 07-Aug-2023 12:52:54 0 NaN 0.8125 07-Aug-2023 12:52:55 0 NaN 0.8125 07-Aug-2023 12:52:56 0 NaN 0.8125 07-Aug-2023 12:52:57 0 NaN 0.8125 07-Aug-2023 12:52:58 0 NaN 0.8125 07-Aug-2023 12:52:59 0 NaN 0.8125 07-Aug-2023 12:53:00 0 NaN 0.8125 07-Aug-2023 12:53:01 0 NaN 0.8125 07-Aug-2023 12:53:02 0 NaN 0.8125 07-Aug-2023 12:53:03 0 NaN 0.8125 07-Aug-2023 12:53:04 0 NaN 0.8125 07-Aug-2023 12:53:05 0 NaN 0.8125 07-Aug-2023 12:53:06 0 NaN 0.8125 07-Aug-2023 12:53:07 0 NaN 0.8125 07-Aug-2023 12:53:08 0 NaN 0.8125 07-Aug-2023 12:53:09 0 NaN 0.8125 07-Aug-2023 12:53:10 0 NaN 0.8125 07-Aug-2023 12:53:11 0 NaN 0.8125 07-Aug-2023 12:53:12 0 NaN 0.8125 07-Aug-2023 12:53:13 0 NaN 0.8125 07-Aug-2023 12:53:14 0 NaN 0.8125 07-Aug-2023 12:53:15 0 NaN 0.8125 07-Aug-2023 14:01:14 -125 NaN -125 07-Aug-2023 14:01:15 -125 NaN -125 07-Aug-2023 14:01:16 -125 NaN -125 07-Aug-2023 14:01:17 -125 NaN -125 07-Aug-2023 14:01:18 -125 NaN -125 07-Aug-2023 14:01:20 -125 NaN -125 07-Aug-2023 14:01:21 -125 NaN -125 07-Aug-2023 14:01:22 -125 NaN -125 07-Aug-2023 14:01:23 -125 0 -125 07-Aug-2023 14:01:24 -125 0 -125 07-Aug-2023 14:01:25 0 0 0.125 07-Aug-2023 14:01:26 0 0 0.5 07-Aug-2023 14:01:27 0 NaN 0.75 07-Aug-2023 14:01:29 0 0 0.75 07-Aug-2023 14:01:30 0 0 0.75 07-Aug-2023 14:01:31 0 0 0.75 07-Aug-2023 14:01:32 0 0 0.75 07-Aug-2023 14:01:33 0 0 0.75 07-Aug-2023 14:01:34 0 0 0.75 07-Aug-2023 14:01:35 0 0 0.75 07-Aug-2023 14:01:36 0 0 0.75 07-Aug-2023 14:01:37 0 0 0.75 07-Aug-2023 14:01:38 0 0 0.75 07-Aug-2023 14:01:39 0 0 0.75 07-Aug-2023 14:01:40 0 0 0.75 07-Aug-2023 14:01:41 0 0 0.75 07-Aug-2023 14:01:42 0 0 0.75 07-Aug-2023 14:01:43 0 NaN 0.75 07-Aug-2023 14:01:44 0 0 0.75 07-Aug-2023 14:01:45 0 0 0.75 07-Aug-2023 14:01:46 0 0 0.75 07-Aug-2023 14:01:47 0 0 0.75 07-Aug-2023 14:01:48 0 0 0.75 07-Aug-2023 14:01:49 0 0 0.75 07-Aug-2023 14:01:50 0 0 0.75 07-Aug-2023 14:01:51 0 0 0.75 07-Aug-2023 14:01:52 0 0 0.75 07-Aug-2023 14:01:53 0 0 0.75 07-Aug-2023 14:01:54 0 0 0.75 07-Aug-2023 14:01:55 0 0 0.75 07-Aug-2023 14:01:56 0 0 0.75 07-Aug-2023 14:01:57 0 0 0.75 07-Aug-2023 14:01:58 0 0 0.75 07-Aug-2023 14:01:59 0 0 0.75 07-Aug-2023 14:02:00 0 0 0.75 07-Aug-2023 14:02:01 0 0 0.75 07-Aug-2023 14:02:02 0 0 0.75 07-Aug-2023 14:02:03 0 0 0.75 07-Aug-2023 14:02:04 0 0 0.75 07-Aug-2023 14:02:05 0 0 0.75 07-Aug-2023 14:02:06 0 0 0.75 07-Aug-2023 14:02:07 0 0 0.75 07-Aug-2023 14:02:08 0 0 0.75 07-Aug-2023 14:02:09 0 0 0.75 07-Aug-2023 14:02:10 0 0 0.75 07-Aug-2023 14:02:11 0 0 0.75 07-Aug-2023 14:02:12 0 0 0.75 07-Aug-2023 14:02:13 0 0 0.75 07-Aug-2023 14:02:14 0 NaN 0.75 07-Aug-2023 14:02:15 0 0 0.75 07-Aug-2023 14:02:16 0 NaN 0.75 07-Aug-2023 14:02:17 0 NaN 0.75 07-Aug-2023 14:02:18 0 NaN 0.75 07-Aug-2023 14:02:19 0 NaN 0.75 07-Aug-2023 14:02:20 0 NaN 0.75 07-Aug-2023 14:02:21 0 NaN 0.75 07-Aug-2023 14:02:22 0 NaN 0.75 07-Aug-2023 14:02:23 0 NaN 0.75 07-Aug-2023 14:02:24 0 NaN 0.75 07-Aug-2023 14:02:25 0 NaN 0.75 07-Aug-2023 14:02:26 0 NaN 0.75 07-Aug-2023 14:02:27 0 NaN 0.75 07-Aug-2023 14:02:28 0 NaN 0.75 07-Aug-2023 14:02:29 0 NaN 0.75 07-Aug-2023 14:02:30 0 NaN 0.75 07-Aug-2023 14:02:31 0 NaN 0.75 07-Aug-2023 14:02:32 0 NaN 0.75 07-Aug-2023 14:02:33 0 NaN 0.75 07-Aug-2023 14:02:34 0 NaN 0.75 07-Aug-2023 14:02:35 0 NaN 0.75 07-Aug-2023 14:02:36 0 NaN 0.75 07-Aug-2023 14:02:37 0 NaN 0.75 07-Aug-2023 14:02:38 0 NaN 0.75 07-Aug-2023 14:02:39 0 NaN 0.75 07-Aug-2023 14:02:40 0 NaN 0.75 07-Aug-2023 14:02:41 0 NaN 0.75 07-Aug-2023 14:02:42 0 NaN 0.75 07-Aug-2023 14:02:43 0 NaN 0.75 07-Aug-2023 14:02:44 0 NaN 0.75 07-Aug-2023 14:02:45 0 NaN 0.75 07-Aug-2023 14:02:46 0 NaN 0.75 07-Aug-2023 14:02:47 0 NaN 0.75 07-Aug-2023 14:02:48 0 NaN 0.75 07-Aug-2023 14:02:49 0 NaN 0.75 07-Aug-2023 14:02:50 -125 0 -125 07-Aug-2023 14:02:51 0 0 0.0625 07-Aug-2023 14:02:52 0 0 0.4375 07-Aug-2023 14:02:53 0 0 0.75 07-Aug-2023 14:02:54 0 0 0.75 07-Aug-2023 14:02:55 0 0 0.75 07-Aug-2023 14:02:56 0 0 0.75 07-Aug-2023 14:02:57 0 0 0.75 07-Aug-2023 14:02:58 0 0 0.75 07-Aug-2023 14:02:59 0 0 0.75
2. Use the nearest State value that exists:
AllData = synchronize(Data1,Data2,Data3,Data1.Time,'nearest');
disp(AllData)
Time State_Data1 State_Data2 State_Data3 ____________________ ___________ ___________ ___________ 07-Aug-2023 12:52:00 0 0 0.8125 07-Aug-2023 12:52:01 0 0 0.8125 07-Aug-2023 12:52:02 0 0 0.8125 07-Aug-2023 12:52:03 0 0 0.8125 07-Aug-2023 12:52:04 0 0 0.8125 07-Aug-2023 12:52:05 0 0 0.8125 07-Aug-2023 12:52:06 0 0 0.8125 07-Aug-2023 12:52:07 0 0 0.8125 07-Aug-2023 12:52:08 0 0 0.8125 07-Aug-2023 12:52:09 0 0 0.8125 07-Aug-2023 12:52:10 0 0 0.8125 07-Aug-2023 12:52:11 0 0 0.8125 07-Aug-2023 12:52:12 0 0 0.8125 07-Aug-2023 12:52:13 0 0 0.8125 07-Aug-2023 12:52:14 0 0 0.8125 07-Aug-2023 12:52:15 0 0 0.8125 07-Aug-2023 12:52:16 0 0 0.8125 07-Aug-2023 12:52:17 0 0 0.8125 07-Aug-2023 12:52:18 0 0 0.8125 07-Aug-2023 12:52:19 0 0 0.8125 07-Aug-2023 12:52:20 0 0 0.8125 07-Aug-2023 12:52:21 0 0 0.8125 07-Aug-2023 12:52:22 0 0 0.8125 07-Aug-2023 12:52:23 0 0 0.8125 07-Aug-2023 12:52:24 0 0 0.8125 07-Aug-2023 12:52:25 0 0 0.8125 07-Aug-2023 12:52:26 0 0 0.8125 07-Aug-2023 12:52:27 0 0 0.8125 07-Aug-2023 12:52:28 0 0 0.8125 07-Aug-2023 12:52:29 0 0 0.8125 07-Aug-2023 12:52:30 0 0 0.8125 07-Aug-2023 12:52:31 0 0 0.8125 07-Aug-2023 12:52:32 0 0 0.8125 07-Aug-2023 12:52:33 0 0 0.8125 07-Aug-2023 12:52:34 0 0 0.8125 07-Aug-2023 12:52:35 0 0 0.8125 07-Aug-2023 12:52:36 0 0 0.8125 07-Aug-2023 12:52:37 0 0 0.8125 07-Aug-2023 12:52:38 0 0 0.8125 07-Aug-2023 12:52:39 0 0 0.8125 07-Aug-2023 12:52:40 0 0 0.8125 07-Aug-2023 12:52:41 0 0 0.8125 07-Aug-2023 12:52:42 0 0 0.8125 07-Aug-2023 12:52:43 0 0 0.8125 07-Aug-2023 12:52:44 0 0 0.8125 07-Aug-2023 12:52:45 0 0 0.8125 07-Aug-2023 12:52:46 0 0 0.8125 07-Aug-2023 12:52:47 0 0 0.8125 07-Aug-2023 12:52:48 0 0 0.8125 07-Aug-2023 12:52:49 0 0 0.8125 07-Aug-2023 12:52:50 0 0 0.8125 07-Aug-2023 12:52:51 0 0 0.8125 07-Aug-2023 12:52:52 0 0 0.8125 07-Aug-2023 12:52:53 0 0 0.8125 07-Aug-2023 12:52:54 0 0 0.8125 07-Aug-2023 12:52:55 0 0 0.8125 07-Aug-2023 12:52:56 0 0 0.8125 07-Aug-2023 12:52:57 0 0 0.8125 07-Aug-2023 12:52:58 0 0 0.8125 07-Aug-2023 12:52:59 0 0 0.8125 07-Aug-2023 12:53:00 0 0 0.8125 07-Aug-2023 12:53:01 0 0 0.8125 07-Aug-2023 12:53:02 0 0 0.8125 07-Aug-2023 12:53:03 0 0 0.8125 07-Aug-2023 12:53:04 0 0 0.8125 07-Aug-2023 12:53:05 0 0 0.8125 07-Aug-2023 12:53:06 0 0 0.8125 07-Aug-2023 12:53:07 0 0 0.8125 07-Aug-2023 12:53:08 0 0 0.8125 07-Aug-2023 12:53:09 0 0 0.8125 07-Aug-2023 12:53:10 0 0 0.8125 07-Aug-2023 12:53:11 0 0 0.8125 07-Aug-2023 12:53:12 0 0 0.8125 07-Aug-2023 12:53:13 0 0 0.8125 07-Aug-2023 12:53:14 0 0 0.8125 07-Aug-2023 12:53:15 0 0 0.8125 07-Aug-2023 14:01:14 -125 0 -125 07-Aug-2023 14:01:15 -125 0 -125 07-Aug-2023 14:01:16 -125 0 -125 07-Aug-2023 14:01:17 -125 0 -125 07-Aug-2023 14:01:18 -125 0 -125 07-Aug-2023 14:01:20 -125 0 -125 07-Aug-2023 14:01:21 -125 0 -125 07-Aug-2023 14:01:22 -125 0 -125 07-Aug-2023 14:01:23 -125 0 -125 07-Aug-2023 14:01:24 -125 0 -125 07-Aug-2023 14:01:25 0 0 0.125 07-Aug-2023 14:01:26 0 0 0.5 07-Aug-2023 14:01:27 0 0 0.75 07-Aug-2023 14:01:29 0 0 0.75 07-Aug-2023 14:01:30 0 0 0.75 07-Aug-2023 14:01:31 0 0 0.75 07-Aug-2023 14:01:32 0 0 0.75 07-Aug-2023 14:01:33 0 0 0.75 07-Aug-2023 14:01:34 0 0 0.75 07-Aug-2023 14:01:35 0 0 0.75 07-Aug-2023 14:01:36 0 0 0.75 07-Aug-2023 14:01:37 0 0 0.75 07-Aug-2023 14:01:38 0 0 0.75 07-Aug-2023 14:01:39 0 0 0.75 07-Aug-2023 14:01:40 0 0 0.75 07-Aug-2023 14:01:41 0 0 0.75 07-Aug-2023 14:01:42 0 0 0.75 07-Aug-2023 14:01:43 0 0 0.75 07-Aug-2023 14:01:44 0 0 0.75 07-Aug-2023 14:01:45 0 0 0.75 07-Aug-2023 14:01:46 0 0 0.75 07-Aug-2023 14:01:47 0 0 0.75 07-Aug-2023 14:01:48 0 0 0.75 07-Aug-2023 14:01:49 0 0 0.75 07-Aug-2023 14:01:50 0 0 0.75 07-Aug-2023 14:01:51 0 0 0.75 07-Aug-2023 14:01:52 0 0 0.75 07-Aug-2023 14:01:53 0 0 0.75 07-Aug-2023 14:01:54 0 0 0.75 07-Aug-2023 14:01:55 0 0 0.75 07-Aug-2023 14:01:56 0 0 0.75 07-Aug-2023 14:01:57 0 0 0.75 07-Aug-2023 14:01:58 0 0 0.75 07-Aug-2023 14:01:59 0 0 0.75 07-Aug-2023 14:02:00 0 0 0.75 07-Aug-2023 14:02:01 0 0 0.75 07-Aug-2023 14:02:02 0 0 0.75 07-Aug-2023 14:02:03 0 0 0.75 07-Aug-2023 14:02:04 0 0 0.75 07-Aug-2023 14:02:05 0 0 0.75 07-Aug-2023 14:02:06 0 0 0.75 07-Aug-2023 14:02:07 0 0 0.75 07-Aug-2023 14:02:08 0 0 0.75 07-Aug-2023 14:02:09 0 0 0.75 07-Aug-2023 14:02:10 0 0 0.75 07-Aug-2023 14:02:11 0 0 0.75 07-Aug-2023 14:02:12 0 0 0.75 07-Aug-2023 14:02:13 0 0 0.75 07-Aug-2023 14:02:14 0 0 0.75 07-Aug-2023 14:02:15 0 0 0.75 07-Aug-2023 14:02:16 0 0 0.75 07-Aug-2023 14:02:17 0 0 0.75 07-Aug-2023 14:02:18 0 0 0.75 07-Aug-2023 14:02:19 0 0 0.75 07-Aug-2023 14:02:20 0 0 0.75 07-Aug-2023 14:02:21 0 0 0.75 07-Aug-2023 14:02:22 0 0 0.75 07-Aug-2023 14:02:23 0 0 0.75 07-Aug-2023 14:02:24 0 0 0.75 07-Aug-2023 14:02:25 0 0 0.75 07-Aug-2023 14:02:26 0 0 0.75 07-Aug-2023 14:02:27 0 0 0.75 07-Aug-2023 14:02:28 0 0 0.75 07-Aug-2023 14:02:29 0 0 0.75 07-Aug-2023 14:02:30 0 0 0.75 07-Aug-2023 14:02:31 0 0 0.75 07-Aug-2023 14:02:32 0 0 0.75 07-Aug-2023 14:02:33 0 0 0.75 07-Aug-2023 14:02:34 0 0 0.75 07-Aug-2023 14:02:35 0 0 0.75 07-Aug-2023 14:02:36 0 0 0.75 07-Aug-2023 14:02:37 0 0 0.75 07-Aug-2023 14:02:38 0 0 0.75 07-Aug-2023 14:02:39 0 0 0.75 07-Aug-2023 14:02:40 0 0 0.75 07-Aug-2023 14:02:41 0 0 0.75 07-Aug-2023 14:02:42 0 0 0.75 07-Aug-2023 14:02:43 0 0 0.75 07-Aug-2023 14:02:44 0 0 0.75 07-Aug-2023 14:02:45 0 0 0.75 07-Aug-2023 14:02:46 0 0 0.75 07-Aug-2023 14:02:47 0 0 0.75 07-Aug-2023 14:02:48 0 0 0.75 07-Aug-2023 14:02:49 0 0 0.75 07-Aug-2023 14:02:50 -125 0 -125 07-Aug-2023 14:02:51 0 0 0.0625 07-Aug-2023 14:02:52 0 0 0.4375 07-Aug-2023 14:02:53 0 0 0.75 07-Aug-2023 14:02:54 0 0 0.75 07-Aug-2023 14:02:55 0 0 0.75 07-Aug-2023 14:02:56 0 0 0.75 07-Aug-2023 14:02:57 0 0 0.75 07-Aug-2023 14:02:58 0 0 0.75 07-Aug-2023 14:02:59 0 0 0.75
See the synchronize documentation for other options.
  3 个评论
显示 1更早的评论
Voss
Voss 2024-7-16
Ran in:
You're welcome!
Yes, that's possible. You'll need to define a threshold that specifies the maximum size of the time gap that should be filled in; below I use 59 minutes. Gaps in time whose size is at or smaller than the threshold are filled in, and gaps larger than the threshold are effectively left in place.
The process is: First, the timestamps of the start and end of gaps larger than the threshold are stored, then the synchronized timetable is retimed to impose a regular 1-second interval (thus filling in all gaps, regardless of size), and finally any times in the retimed timetable that are within any large gap are removed (thus removing the filled-in data from the large gaps and effectively re-imposing the large gaps).
Data1 = readtimetable('Data1.xlsx');
Data2 = readtimetable('Data2.xlsx');
Data3 = readtimetable('Data3.xlsx');
% synchronize like before:
AllData = synchronize(Data1,Data2,Data3,Data1.Time,'nearest');
% define a gap threshold:
gap_threshold = minutes(59);
% find the locations of gaps bigger than the threshold:
idx = find(diff(AllData.Time) > gap_threshold);
% record the start and end times of these large gaps:
gap_starts = AllData.Time(idx);
gap_ends = AllData.Time(idx+1);
% retime the timetable, resulting in a 1-second uniform timetable (i.e.,
% all gaps filled in):
AllData = retime(AllData,'regular','nearest','TimeStep',seconds(1));
% now remove the data from within the large gaps:
for ii = 1:numel(gap_starts)
remove_idx = AllData.Time > gap_starts(ii) & AllData.Time < gap_ends(ii);
AllData(remove_idx,:) = [];
end
% check the result:
disp(AllData)
Time State_Data1 State_Data2 State_Data3 ____________________ ___________ ___________ ___________ 07-Aug-2023 12:52:00 0 0 0.8125 07-Aug-2023 12:52:01 0 0 0.8125 07-Aug-2023 12:52:02 0 0 0.8125 07-Aug-2023 12:52:03 0 0 0.8125 07-Aug-2023 12:52:04 0 0 0.8125 07-Aug-2023 12:52:05 0 0 0.8125 07-Aug-2023 12:52:06 0 0 0.8125 07-Aug-2023 12:52:07 0 0 0.8125 07-Aug-2023 12:52:08 0 0 0.8125 07-Aug-2023 12:52:09 0 0 0.8125 07-Aug-2023 12:52:10 0 0 0.8125 07-Aug-2023 12:52:11 0 0 0.8125 07-Aug-2023 12:52:12 0 0 0.8125 07-Aug-2023 12:52:13 0 0 0.8125 07-Aug-2023 12:52:14 0 0 0.8125 07-Aug-2023 12:52:15 0 0 0.8125 07-Aug-2023 12:52:16 0 0 0.8125 07-Aug-2023 12:52:17 0 0 0.8125 07-Aug-2023 12:52:18 0 0 0.8125 07-Aug-2023 12:52:19 0 0 0.8125 07-Aug-2023 12:52:20 0 0 0.8125 07-Aug-2023 12:52:21 0 0 0.8125 07-Aug-2023 12:52:22 0 0 0.8125 07-Aug-2023 12:52:23 0 0 0.8125 07-Aug-2023 12:52:24 0 0 0.8125 07-Aug-2023 12:52:25 0 0 0.8125 07-Aug-2023 12:52:26 0 0 0.8125 07-Aug-2023 12:52:27 0 0 0.8125 07-Aug-2023 12:52:28 0 0 0.8125 07-Aug-2023 12:52:29 0 0 0.8125 07-Aug-2023 12:52:30 0 0 0.8125 07-Aug-2023 12:52:31 0 0 0.8125 07-Aug-2023 12:52:32 0 0 0.8125 07-Aug-2023 12:52:33 0 0 0.8125 07-Aug-2023 12:52:34 0 0 0.8125 07-Aug-2023 12:52:35 0 0 0.8125 07-Aug-2023 12:52:36 0 0 0.8125 07-Aug-2023 12:52:37 0 0 0.8125 07-Aug-2023 12:52:38 0 0 0.8125 07-Aug-2023 12:52:39 0 0 0.8125 07-Aug-2023 12:52:40 0 0 0.8125 07-Aug-2023 12:52:41 0 0 0.8125 07-Aug-2023 12:52:42 0 0 0.8125 07-Aug-2023 12:52:43 0 0 0.8125 07-Aug-2023 12:52:44 0 0 0.8125 07-Aug-2023 12:52:45 0 0 0.8125 07-Aug-2023 12:52:46 0 0 0.8125 07-Aug-2023 12:52:47 0 0 0.8125 07-Aug-2023 12:52:48 0 0 0.8125 07-Aug-2023 12:52:49 0 0 0.8125 07-Aug-2023 12:52:50 0 0 0.8125 07-Aug-2023 12:52:51 0 0 0.8125 07-Aug-2023 12:52:52 0 0 0.8125 07-Aug-2023 12:52:53 0 0 0.8125 07-Aug-2023 12:52:54 0 0 0.8125 07-Aug-2023 12:52:55 0 0 0.8125 07-Aug-2023 12:52:56 0 0 0.8125 07-Aug-2023 12:52:57 0 0 0.8125 07-Aug-2023 12:52:58 0 0 0.8125 07-Aug-2023 12:52:59 0 0 0.8125 07-Aug-2023 12:53:00 0 0 0.8125 07-Aug-2023 12:53:01 0 0 0.8125 07-Aug-2023 12:53:02 0 0 0.8125 07-Aug-2023 12:53:03 0 0 0.8125 07-Aug-2023 12:53:04 0 0 0.8125 07-Aug-2023 12:53:05 0 0 0.8125 07-Aug-2023 12:53:06 0 0 0.8125 07-Aug-2023 12:53:07 0 0 0.8125 07-Aug-2023 12:53:08 0 0 0.8125 07-Aug-2023 12:53:09 0 0 0.8125 07-Aug-2023 12:53:10 0 0 0.8125 07-Aug-2023 12:53:11 0 0 0.8125 07-Aug-2023 12:53:12 0 0 0.8125 07-Aug-2023 12:53:13 0 0 0.8125 07-Aug-2023 12:53:14 0 0 0.8125 07-Aug-2023 12:53:15 0 0 0.8125 07-Aug-2023 14:01:14 -125 0 -125 07-Aug-2023 14:01:15 -125 0 -125 07-Aug-2023 14:01:16 -125 0 -125 07-Aug-2023 14:01:17 -125 0 -125 07-Aug-2023 14:01:18 -125 0 -125 07-Aug-2023 14:01:19 -125 0 -125 07-Aug-2023 14:01:20 -125 0 -125 07-Aug-2023 14:01:21 -125 0 -125 07-Aug-2023 14:01:22 -125 0 -125 07-Aug-2023 14:01:23 -125 0 -125 07-Aug-2023 14:01:24 -125 0 -125 07-Aug-2023 14:01:25 0 0 0.125 07-Aug-2023 14:01:26 0 0 0.5 07-Aug-2023 14:01:27 0 0 0.75 07-Aug-2023 14:01:28 0 0 0.75 07-Aug-2023 14:01:29 0 0 0.75 07-Aug-2023 14:01:30 0 0 0.75 07-Aug-2023 14:01:31 0 0 0.75 07-Aug-2023 14:01:32 0 0 0.75 07-Aug-2023 14:01:33 0 0 0.75 07-Aug-2023 14:01:34 0 0 0.75 07-Aug-2023 14:01:35 0 0 0.75 07-Aug-2023 14:01:36 0 0 0.75 07-Aug-2023 14:01:37 0 0 0.75 07-Aug-2023 14:01:38 0 0 0.75 07-Aug-2023 14:01:39 0 0 0.75 07-Aug-2023 14:01:40 0 0 0.75 07-Aug-2023 14:01:41 0 0 0.75 07-Aug-2023 14:01:42 0 0 0.75 07-Aug-2023 14:01:43 0 0 0.75 07-Aug-2023 14:01:44 0 0 0.75 07-Aug-2023 14:01:45 0 0 0.75 07-Aug-2023 14:01:46 0 0 0.75 07-Aug-2023 14:01:47 0 0 0.75 07-Aug-2023 14:01:48 0 0 0.75 07-Aug-2023 14:01:49 0 0 0.75 07-Aug-2023 14:01:50 0 0 0.75 07-Aug-2023 14:01:51 0 0 0.75 07-Aug-2023 14:01:52 0 0 0.75 07-Aug-2023 14:01:53 0 0 0.75 07-Aug-2023 14:01:54 0 0 0.75 07-Aug-2023 14:01:55 0 0 0.75 07-Aug-2023 14:01:56 0 0 0.75 07-Aug-2023 14:01:57 0 0 0.75 07-Aug-2023 14:01:58 0 0 0.75 07-Aug-2023 14:01:59 0 0 0.75 07-Aug-2023 14:02:00 0 0 0.75 07-Aug-2023 14:02:01 0 0 0.75 07-Aug-2023 14:02:02 0 0 0.75 07-Aug-2023 14:02:03 0 0 0.75 07-Aug-2023 14:02:04 0 0 0.75 07-Aug-2023 14:02:05 0 0 0.75 07-Aug-2023 14:02:06 0 0 0.75 07-Aug-2023 14:02:07 0 0 0.75 07-Aug-2023 14:02:08 0 0 0.75 07-Aug-2023 14:02:09 0 0 0.75 07-Aug-2023 14:02:10 0 0 0.75 07-Aug-2023 14:02:11 0 0 0.75 07-Aug-2023 14:02:12 0 0 0.75 07-Aug-2023 14:02:13 0 0 0.75 07-Aug-2023 14:02:14 0 0 0.75 07-Aug-2023 14:02:15 0 0 0.75 07-Aug-2023 14:02:16 0 0 0.75 07-Aug-2023 14:02:17 0 0 0.75 07-Aug-2023 14:02:18 0 0 0.75 07-Aug-2023 14:02:19 0 0 0.75 07-Aug-2023 14:02:20 0 0 0.75 07-Aug-2023 14:02:21 0 0 0.75 07-Aug-2023 14:02:22 0 0 0.75 07-Aug-2023 14:02:23 0 0 0.75 07-Aug-2023 14:02:24 0 0 0.75 07-Aug-2023 14:02:25 0 0 0.75 07-Aug-2023 14:02:26 0 0 0.75 07-Aug-2023 14:02:27 0 0 0.75 07-Aug-2023 14:02:28 0 0 0.75 07-Aug-2023 14:02:29 0 0 0.75 07-Aug-2023 14:02:30 0 0 0.75 07-Aug-2023 14:02:31 0 0 0.75 07-Aug-2023 14:02:32 0 0 0.75 07-Aug-2023 14:02:33 0 0 0.75 07-Aug-2023 14:02:34 0 0 0.75 07-Aug-2023 14:02:35 0 0 0.75 07-Aug-2023 14:02:36 0 0 0.75 07-Aug-2023 14:02:37 0 0 0.75 07-Aug-2023 14:02:38 0 0 0.75 07-Aug-2023 14:02:39 0 0 0.75 07-Aug-2023 14:02:40 0 0 0.75 07-Aug-2023 14:02:41 0 0 0.75 07-Aug-2023 14:02:42 0 0 0.75 07-Aug-2023 14:02:43 0 0 0.75 07-Aug-2023 14:02:44 0 0 0.75 07-Aug-2023 14:02:45 0 0 0.75 07-Aug-2023 14:02:46 0 0 0.75 07-Aug-2023 14:02:47 0 0 0.75 07-Aug-2023 14:02:48 0 0 0.75 07-Aug-2023 14:02:49 0 0 0.75 07-Aug-2023 14:02:50 -125 0 -125 07-Aug-2023 14:02:51 0 0 0.0625 07-Aug-2023 14:02:52 0 0 0.4375 07-Aug-2023 14:02:53 0 0 0.75 07-Aug-2023 14:02:54 0 0 0.75 07-Aug-2023 14:02:55 0 0 0.75 07-Aug-2023 14:02:56 0 0 0.75 07-Aug-2023 14:02:57 0 0 0.75 07-Aug-2023 14:02:58 0 0 0.75 07-Aug-2023 14:02:59 0 0 0.75

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

产品


版本

R2024a

Community Treasure Hunt

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

Start Hunting!

Translated by