Make this .mat variable DOUBLE- Help needed

hello all

I want to make this attached .mat file to double, in order to use in griddedInterpolant function alongside some other doubled variables. I really search for it but can't find the answer. it doesn't matter to DateTime format keep, I just want the text that shows which row is what date. I've attached t.mat.

Thanks for your attention. I’m looking forward to your reply.

Answer 1

[Bhaskar R]

Hi,

load t;
date_data = datetime(cell2mat(t));    % to get the all data as datetime format
date_data_double = datevec(date_data);     % convert the datetime data to double data in 6 columns

Hope helps you !

[BN]

Dear Bhaskar,

I really appreciate your help. is there any way to have date_data_double in one column?

actually I need the 408*1 dimension, not 408*6

thank you

[Bhaskar R]

Anyway you can get the double datatype serial value from the datetime data.

date_data_double = datenum(date_data);    % as serial double data

Now your data is in 408*1 dimension

You can convert back this data to datetime data as

datetime_back = datetime(date_data_double, 'ConvertFrom','datenum');