Load (xlsread) a especific time sample

In spreadsheet attached, how can i do a rotine to load (with xlsread) a especific time sample (example: 00:01:24 to 00:05:03)?

Answer 1

[Star Strider]

If your file is formatted the same as in Heart Rate by category, you cannot. You have to read the entire file, parse the column, Convert to the appropriate formats, then do the selections:

[~,sc] = xlsread('TEST.csv');
t_rc = regexp(sc(2:end), ';','split');                      % Parse Column
dn = cellfun(@(x) datenum(x(:,1), 'HH:MM:SS'), t_rc);       % Convert To Date Numbers
hr = cellfun(@(x) str2double(x(:,2)), t_rc);                % Convert To Doubles

[Sérgio Querido]

Ok!! Do you know the code to do the selection, after appropriate formats??

[Star Strider]

Yes!

The Code —

[~,sc] = xlsread('Sérgio Querido TEST.csv');
t_rc = regexp(sc(2:end), ';','split');                      % Parse Column
dn = cellfun(@(x) datenum(x(:,1), 'HH:MM:SS'), t_rc);
hr = cellfun(@(x) str2double(x(:,2)), t_rc);

dn_range = datenum(['00:01:24'; '00:05:03'],  'HH:MM:SS');
idx = find((dn >= dn_range(1)) & (dn <= dn_range(2)));

The ‘idx’ variable has the row indices for the times that meet the criteria.