Error using datetime Input data must be one numeric matrix when converting from a different date/time representation.

Hi Everyone,

I am trying to export time data from excel and to but in format HH:mm and remove the date and year but I am getting the error "Error using datetime Input data must be one numeric matrix when converting from a different date/time representation."

The code is attached:

[file,path] = uigetfile('*.xlsx','Select a File'); %Opening modal dialog box to get the excel file (xlsx ensures that only excel files are shown)
            fpath=[path,file];  % File path of excel file
            app.FilePathEditField.Value=fpath; % Assigning the file path to the edit field area
            app.H = readtable(app.FilePathEditField.Value);
            app.H.Time_24HourClock_= datetime(app.H.Time_24HourClock_,'ConvertFrom','excel','Format','HH:mm');% Here has the error
            app.UITable.Data =app.H; 
        

Answer 1

[Cris LaPierre]

We really need to know more about your variable values to say for certain, but I suspect what is happening is that readtable has already read the Time_24HourClock_ data as a datetime. So the error is likely caused by passing a datetime variable as input to datetime.

D = datetime('now');
datetime(D,'ConvertFrom','excel','Format','HH:mm')

Error using datetime
Input data must be one numeric matrix when converting from a different date/time representation.

To change the display format of your table variable Time_24HourClock_, try the following:

app.H.Time_24HourClock_.Format = 'HH:mm';

[tyler seudath]

Thanks a mil! It worked.

[Peter Perkins]

In addition:

Changing the display format does nothing to the actual datetime values in app.H.Time_24HourClock_. They are still dates and times. If your goal is to treat them as times-of-day, you may well be better off calling timeofday on that table variable rather than changing its display format. Hard to tell, though.