No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.
General Tech 10 Answers
General Tech 7 Answers
General Tech 3 Answers
General Tech 9 Answers
manpreet
Best Answer
2 years ago
I have a spreadsheet which contains a sheet called 'Classes' this contains the start (L) and end time (K) of each lesson as well as the duration (J), class code (A) and student name (B) who attends this lesson.
I have to timetable extra lessons around this timetable but students can only have a maximum of 5 hours without a break. Whilst I timetable someone else is also changing the timetable I'm working around so each day I need to be able to run a check to see if any lessons have been moved to give a student too many hours in a row.
The only way I can think to do this is some kind of loop which concats the student name and start time then compares it to a concat of student and end time. When it finds a match it adds the durations together. I need it to return the student and the day where they have too many hours. I have no idea how this might be achieved in VBA bar my suggestion. Any ideas?