MATLAB: Time cell (or char) inside a double array

char string double time convert

Hello, I have a 45×1 cell array, that I can convert to 45×8 char… the single cell is showing time, for example '09:45:46' ..

now, I would like to put this column as the first column of a double precision data array D.

I tried several things I was reading around, but I haven't found anything that could give me the right time as I see it here.

Some tips? Thanks

Best Answer

which matlab release do you use?

dateCells = {'09:45:46','09:45:49'}

dateString = strjoin(dateCells, sprintf('\n'))

result = textscan(dateString, '%d:%d:%d') % for integer results

result = textscan(dateString, '%f:%f:%f') % for double results

Related Solutions

MATLAB: How to write datetime(char array 105819), latitude(11058 double) and longitude (1*1058 double) in txt file using fprintf ??

Assuming that the date-time char vectors are in a cell array:

>> fmt = '%20s \t %2.2f \t %2.2f\n';
>> DT = {'2018-05-16 07:57:12','2018-05-16 07:57:13','2018-05-16 07:57:14'};
>> LA = [23.0347 23.0351 23.0353];
>> LO = [72.5399 72.5398 7253.93];
>> C = DT;
>> C(2,:) = num2cell(LA);
>> C(3,:) = num2cell(LO);
>> fprintf(fmt,C{:})
2018-05-16 07:57:12     23.03   72.54
2018-05-16 07:57:13     23.04   72.54
2018-05-16 07:57:14     23.04   7253.93

Note that a loop is not required. If you really do have a char array with size 1058x19 then use this:

C = cellstr(DT).';

MATLAB: 15 minutes intervals

Determine the first date of the range. Find the datenum() of midnight on that day. Convert the other values in to datenum() and subtract that base of midnight. Divide the resulting difference by (15*60)/(24*60*60) = 1/(24*60/15) = 1/(24*4) = 1/96 -- so multiply by 96 to do the division. Take the floor() of the result and that vector will be the number of 15 minute bins since midnight on the base date.

Once you have those bin numbers, you can add 1 to each of them and use the result as the subscript for the purposes of accumarray:

accumarray(1+binnum(:), stockprice(:), [], @mean)

Best Answer

Related Solutions

MATLAB: How to write datetime(char array 1058*19), latitude(1*1058 double) and longitude (1*1058 double) in txt file using fprintf ??

MATLAB: 15 minutes intervals

Related Question

MATLAB: How to write datetime(char array 105819), latitude(11058 double) and longitude (1*1058 double) in txt file using fprintf ??