MATLAB: How to create a time stamp with 5 minutes interval

functiontime stamp

Hi everyone! I still trying to solve the next problem, sorry for too much asking but I really need to solve this:

I have two columns column A are dates and times and column B are prices. Column A is in Matlab format and looks like this:

[02-Jan-1990 10:09:00
02-Jan-1990 10:10:00 
02-Jan-1990 10:11:00
02-Jan-1990 10:12:00 ...]

the variable description is char

And column B:

[353.400
353.2500
353.0200
352.9700
...]

the variable description is double

I need to rearrange A column so it gives me the prices in 5 minutes intervals and the corresponding price B (now I have them for every minute).

Column A goes from 1990 until 2016 so the calculation has to consider changes in days, months and years.

Thanks a lot for your help!

Best Answer

A(1:5:end)
B(1:5:end)

Related Solutions

MATLAB: How to extract time (HH:mm) from datetime from a table and plot it in interval range

Note that the format of the datetime array is irrelevant. It is only used for display. You could of course change the Format so that it only shows hours and minutes but calculations would still involve the date as well.

You use the hour and minute functions to extract the hours and minutes from a datetime array. Alternatively, you use the Hour and Minute properties of the datetime object.

d = datetime + hours(1:10)' + minutes(1:10)';  %create demo datetime a array
hour(d)   %get the hour
d.Hour    %another way

minute(d) %get the minute
d.Minute  %another way

As for the plot, I'm unclear what you want to do. If two values have the same hours and minutes but different day, do you want to plot them at the same abscissa, like a scatter plot?

MATLAB: Indexing different time ranges from a Timetable.

"First is I want to select all times from 11am to 12pm irrespective of the date. "

% Make fake data
MeasurementTime = (datetime('2018-12-01 01:00') : 0.05 : datetime('2019-04-01 11:30 PM'))';
Temperature = randi(100, size(MeasurementTime)); 
TT = timetable(MeasurementTime,Temperature);
% Extract hour of day (24 hr format)

hourOfDay = hour(TT.MeasurementTime); 
% Determine which time stamps are between 11am and 12pm
b = [11, 12]; %[start, end] of desired time bounds (24 hr format)

selectedTimes = hourOfDay >= b(1) & hourOfDay <= b(2); 
% isolate all rows of timetable between desired time bounds
TT(selectedTimes,:)

"Second is I want to select all times from 11am to 12pm through a range of months say Jan-Mar"

% Extract hour of day (24 hr format)
hourOfDay = hour(TT.MeasurementTime); 
% Extract month number
monthNum = month(TT.MeasurementTime); 
% Determine which time stamps are between 11am and 12pm for january to march
b = [11, 12]; %[start, end] of desired time bounds (24 hr format)
m = [1, 3];   %[start, end] of desired month bounds
selectedTimes = hourOfDay >= b(1) & hourOfDay <= b(2); 
selectedMonths = monthNum >= m(1) & monthNum <= m(2); 
% isolate all rows of timetable between desired time and month bounds
TT(selectedTimes & selectedMonths,:)

Best Answer

Related Solutions

MATLAB: How to extract time (HH:mm) from datetime from a table and plot it in interval range

MATLAB: Indexing different time ranges from a Timetable.

Related Question