Datenum error..how to fix

    bouts_data = [datenum(raw_bouts_data(2:end,5), 'dd/mm/yyyy HH:MM:SS PM'), ...
          datenum(raw_bouts_data(2:end,6), 'dd/mm/yyyy HH:MM:SS PM'), ...
          cell2mat(raw_bouts_data(2:end,7:end))];

• Error in DataLogger_DailyBouts (line 36) bouts_data = [datenum(raw_bouts_data(2:end,5), 'dd/mm/yyyy HH:MM:SS PM'), ...

Caused by: Error using datenum (line 107) The input to DATENUM was not an array of strings.*

I'm trying to read an excel file and I get this error why? How to fix it?

[Robert U]

Hi, my first guess would be that you read your Excel sheet by utilizing

[num,txt,raw] = xlsread(___)

where your output raw_bouts_data is representing the "raw"-output from xlsread().

Writing now raw_bouts_data(2:end,5) gives you a cell whereas you need a string:

[datenum(raw_bouts_data{2:end,5}, 'dd/mm/yyyy HH:MM:SS PM'), ...
        datenum(raw_bouts_data{2:end,6}, 'dd/mm/yyyy HH:MM:SS PM'), ...
        cell2mat(raw_bouts_data(2:end,7:end))];

Kind regards,

Robert Uhlig