I want to set time when i plot graph (in gui)

1 次查看（过去 30 天）

显示更早的评论

woongki park 2018-8-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/415192-i-want-to-set-time-when-i-plot-graph-in-gui

评论： Walter Roberson 2018-8-18

采纳的回答： Walter Roberson

在 MATLAB Online 中打开

when i put

           09:12:45 ->Edit text 1
           12:00:12 ->Edit text 2

i want to plot graph between text 1 and text 2 time

is it possible?

at first i imported data from excel

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2018-8-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/415192-i-want-to-set-time-when-i-plot-graph-in-gui#answer_333077

在 MATLAB Online 中打开

If you convert to a timetable() object then you can use timerange() to subscript the entries.

If you do not use a timetable() object, then you can use standard logical masks, like

start_dur = duration( get(handles.text1, 'String') );
end_dur = duration( get(handles.text2, 'String') );
dur_column = YourArray{:,3};   %select appropriate duration column, method will vary according to how you stored your data
mask = dur_column >= start_dur & dur_column <= end_dur;
selected_data = YourArray{mask, :};   %method will vary according to how you stored your data

Now you can plot from selected_data

13 个评论
显示 11更早的评论隐藏 11更早的评论

woongki park 2018-8-17

编辑：woongki park 2018-8-17

 handles.fileName=uigetfile('*.xls');
 fileName=handles.fileName;
 [~,txt,~]=xlsread(fileName,'C27:C30000');   
 [Ch1,~,~]=xlsread(fileName,'E27:E30000');
 [Ch2,~,~]=xlsread(fileName,'F27:F30000');
 [Ch3,~,~]=xlsread(fileName,'G27:G30000');
 [Ch4,~,~]=xlsread(fileName,'H27:H30000');
 [Ch5,~,~]=xlsread(fileName,'I27:I30000');
 [Ch6,~,~]=xlsread(fileName,'J27:J30000');
 [Ch7,~,~]=xlsread(fileName,'K27:K30000');
 [Ch8,~,~]=xlsread(fileName,'L27:L30000');
 [Ch9,~,~]=xlsread(fileName,'M27:M30000');
 [Ch10,~,~]=xlsread(fileName,'N27:N30000');
 [Ch11,~,~]=xlsread(fileName,'O27:O30000');
 [Ch12,~,~]=xlsread(fileName,'P27:P30000'); 
 [Ch13,~,~]=xlsread(fileName,'Q27:Q30000');
 [Ch14,~,~]=xlsread(fileName,'R27:R30000');
 [Ch15,~,~]=xlsread(fileName,'S27:S30000');
 [Ch16,~,~]=xlsread(fileName,'T27:T30000');
 [Ch17,~,~]=xlsread(fileName,'U27:U30000');
 [Ch18,~,~]=xlsread(fileName,'V27:V30000');
 [Ch19,~,~]=xlsread(fileName,'W27:W30000');
 [Ch20,~,~]=xlsread(fileName,'X27:X30000');

 char(txt);   %txt is time 
 DateNumber=datenum(txt);
 Date=datetime(DateNumber,'ConvertFrom', 'excel');  
 Date1=datetime(Date,'Format','hh:mm:ss');

i use datetime type

woongki park 2018-8-18

编辑：woongki park 2018-8-18

it doesn't work.duration function still have problem. dateshift are not working with duration function

how about using datetime instead of duration

Walter Roberson 2018-8-18

在 MATLAB Online 中打开

Date1 = datetime(txt, 'InputFormat', 'hh:mm:ss', 'Format', 'hh:mm:ss');
start_dur = datetime( get(handles.text1, 'String') );
end_dur = datetime( get(handles.text2, 'String') );
Date1 = Date1 - dateshift(Date1, 'start', 'day');
start_dur = start_dur - dateshift(start_dur, 'start', 'day');
end_dur = end_dur - dateshift(end_dur, 'start', 'day');