Populating time blocks for classes

[fil1951]

Hello,

Been looking for a way to populate corresponding time blocks for classes based on time ranges in another sheet. If anyone can help with either formula or VBA to get sheet 3 to populate how I need the data it is greatly appreciated.

Sheet 1 contains blocks of times in 5 minute intervals with an associated "Period ID" and start and end times


Sheet 2 contains a list of classes with start and end times



I need sheet 3 to list all of the classes with all of the corresponding "Period IDs" that the class runs for. There will be multiple classes that run during the same period ID.

 

[awoohaw]

You have classes during the same time period:

Mr excel questions 67.xlsm
	E	F	G	H
1	Class Nbr	Start Time	End Time	Conflict.
2	Math1	9:00 AM	9:05 AM	All 5 Minutes is in Match 3
3	Math3	9:00 AM	9:30 AM	First 5 minutes is in Math1
4	English2	9:15 AM	10:00 AM	First 15 minutes is in Math 3
5	Math2	10:15 AM	11:00 AM
fil1951

Cell Formulas
Range	Formula
F2:F3	F2	=TIME(9,0,0)
G2	G2	=TIME(9,5,0)
G3	G3	=TIME(9,30,0)
F4	F4	=TIME(9,15,0)
G4	G4	=TIME(10,0,0)
F5	F5	=TIME(10,15,0)
G5	G5	=TIME(11,0,0)

Did you miss giving an additional differentiator?