How do I read (hours) data from the .xlsx file?

Hello,

I have the following issue. In a .xlsx file I have in column D hours (format: 00: 00: 00,01: 00: 00, ... 23:00:00). How can I integrate (read) them into the code to use them to plot some graphics I want. Your help is important.

Answer 1

[Walter Roberson]

[~,~,ALL_Data]=xlsread('Hours_Data.xlsx');
Hours = days(cell2mat(ALL_Data(2:25,end)));
Hours.Format = 'hh:mm';
Hours

Hours = 24×1 duration array
   00:00
   01:00
   02:00
   03:00
   04:00
   05:00
   06:00
   07:00
   08:00
   09:00
   10:00
   11:00
   12:00
   13:00
   14:00
   15:00
   16:00
   17:00
   18:00
   19:00
   20:00
   21:00
   22:00
   23:00

%OR
ALL_Data = readtable('Hours_Data.xlsx');
Hours = days(ALL_Data{:,end});
Hours.Format = 'hh:mm';
Hours

Hours = 24×1 duration array
   00:00
   01:00
   02:00
   03:00
   04:00
   05:00
   06:00
   07:00
   08:00
   09:00
   10:00
   11:00
   12:00
   13:00
   14:00
   15:00
   16:00
   17:00
   18:00
   19:00
   20:00
   21:00
   22:00
   23:00

[stelios loizidis]

It works. Thank you very much for the valuable help !!!

Answer 2

[KSSV]

Read about readtable. In here after reading your specify the format of time. Have a look on duration.

[stelios loizidis]

Below is the code:

[~,~,ALL_Data]=xlsread('Data.xlsx',"Data");
Hours=duration(ALL_Data(3:25,4)); % column where the hours are located

The following error occurs:

Error using duration (line 278)
Input data must be numeric, or a cell or string array containing duration text.

Error in ELM_Days_Separation (line 12)
Hours=duration(ALL_Data(3:25,4));

[Walter Roberson]

We do not know what form column 4 of your xlsx file is in.

Which MATLAB release are you using?

Can you attach a small .xlsx file for testing?

[stelios loizidis]

I am using : MATLAB 2020

[Walter Roberson]

Can you attach a small .xlsx file for testing? Excel files have multiple ways of representing times. I suspect that you are looking at a numeric field that a time format has been applied to.

[stelios loizidis]

Exactly. In column D I have the hours in the following format:

00:00

01:00

02:00

....

23:00

[Walter Roberson]

If the answer is NO, that you have technical problems or legal restrictions that prevent you from uploading a small sample file, then just say so, and we will provide additional steps to figure out exactly what is happening. But if you were hoping for an answer soon and there is no technical or legal restriction to uploading a small sample file then upload a small sample file

We. Need. To. See. Exactly. What. Is. Stored. In. The. File.

Not what an image of it looks like. Excel permits many different kinds of data to be displayed as the same thing.

[stelios loizidis]

Attach the file