I have a table of college classes that are uniquely identified by their Reference number. If a student is in class for 8 or more hours, they get 1 hour lunch break. The data set I am given breaks up the whole class day if there is a lunch break. Is there any way with VBA to combine the rows so each class/date range has one row? I would also like to have the total hours for the class day to show up in the last column.
Can VBA do something like this? Many thanks!!!
combined.xlsx
Bookmarks