How to seperate weekdays and weekends from an hourly data?

I have a data in excel which has data in yyyy-mm-dd hr:min:sec Am/PM format and I want to separate this data to weekdays and weekends without doing any average of it. How do I do it?

Thank Mahavir

Answer 1

[Von Duesenberg]

Here's what I do (byHourTable is a timetable object with a column called Timestamps):

%get day names
[~, dayNames] = weekday(byHourTable.Timestamps, 'short');
%find indices of week days
indWorkDay = ismember(dayNames, {'Mon', 'Tue', 'Wed', 'Thu', 'Frid'});
%extract data for week days only
aggrDay = byHourTable(indWorkDay,:);

[Steph]

this approach works, need to change Frid to Fri only