MATLAB: Converting time variable in excel into datetime datatype

MATLAB

I imported time from excel file using readtable and it seems that the variable time is in text form. My time in excel has this format: 20190101:1700 How can i convert this in to datetime datatype in matlab

Best Answer

Assuming the date format and that the rows are character arrays, try this:

dtc = '20190101:1700';
dt = datetime(dtc, 'InputFormat','yyyyMMdd:HHmm')

producing:

dt = 
  datetime
   01-Jan-2019 17:00:00

Related Solutions

MATLAB: Convert date to datetime

t = datetime(DateStrings,'InputFormat','dd/MM/yyyy');

MATLAB: Datatypes

Your command

double e1,e2,e;

is equivalent to

double('e1')
e2
e

'e1' is a string, which is an array of character, and applying double to the array of character returns the numeric values of each of the characters: that happens to be 101 for 'e' and 49 for '2'. For more information on this, please see Command vs Function syntax

In MATLAB, one does not declare variables as being of a particular type: one just assigns values and the variable assumes the type of the values if the variable appears by itself (without any kind of indexing) in an assignment syntax.

Best Answer

Related Solutions

MATLAB: Convert date to datetime

MATLAB: Datatypes

Related Question