select data from table according to date and time

Hallo,

I need your help for matlab.

I have a table with dates and times data for 7 days. I want to select records between 14:00 to 16:00 for each day?!

Thanks

[Walter Roberson]

Are the times in a separate variable in the table, or do you have a single datetime column?

If the times are in a separate variable in the table, then what format are they in?

[MOMO JOJO]

Dear Walter,

The times are in the same table. Some of data are mentionned bellow. They are for 7 days

'08-Feb-2019 11:03:40'

'08-Feb-2019 11:08:40'

'08-Feb-2019 11:13:40'

'08-Feb-2019 11:18:40'

Thanks

Answer 1

[Akira Agata]

How about the following way?

% Create sample data
Time = sort(datetime(2019,3,24) + days(7)*rand(1000,1));
Data = rand(1000,1);
T1 = table(Time,Data);

% Select records (row index) between 14:00 to 16:00
idx = (T1.Time.Hour >= 14) & (T1.Time.Hour) < 16;

% Extract selected records
T2 = T1(idx,:);

[MOMO JOJO]

Dear Akira,

It works :-) but if i want to select records between 14:00 to 16:30, what should I add to the prevois code,please.

I have put 16.5 but all records of 16:00 are extracted?

Thank you very much

[Walter Roberson]

idx =(T1.Time.Hour >= 14) & ((T1.Time.Hour < 16) | (T1.Time.Hour == 16 & T1.Time.Minute <= 30));

Or you could do something like

temp = T1.Time.Hour * 60 + T1.Time.Minute;
idx = temp >= 14*60 & temp <= 16*60+30;

[Akira Agata]

Thank you, Walter-san !

[MOMO JOJO]

Thanks dears Walter-san & Akira Agata,

For your grand help.

[Peter Perkins]

isbetween would probably make this more manageable:

>> isbetween(timeofday(datetime),'14:00:00','16:30:00')
ans =
  logical
   1

[Aryan Ritwajeet Jha]

isbetween command is much more convenient.

%Here, the 'time' column in the 'data' table stores the complete time for that instance
%in the format 'dd-MMM-yyyy hh:mm:ss'.
intervalStartTime = '09-Aug-2019 15:50:00';
intervalEndTime = '09-Aug-2019 16:00:00';
idx = isbetween(data.time,intervalStartTime,intervalEndTime);
selectedRows = data(idx,:); %Stores only the rows with the desired time instances

[pruth]

hello,

what if i want to select minutes along with an hour. ? data between 14:30 and 15:30 ? how do i do it ?

[Peter Perkins]

Presumably you would modify my answer from 2-Apr-2019.