Assign times to time slots for locations & days

flashgordie

Board Regular
Joined
Jan 9, 2008
Messages
78
Office Version
  1. 365
Platform
  1. Windows
I know this is a lot to ask but unfortunately, I am not sure where to go from here. I have been working on a spread sheet that will help me develop a schedule.

I have developed my sheet ask the user to input …
• Which days of the week are available,
• The names of the locations they will use,
• And the number of time slots available for each location on each day.

I would like to associate an actual time, with the time slots for each location on the appropriate day.

The chart below shows the information the sheet has collected. The user is prompted to place the # of time slots avaible in the orange cells for the correct day and location. Looking at Sunday…we have 4 time slots available but they are at two different locations. “Room 1” can support 3 meetings, while “Room 4” can only support one meeting. However on Monday this changes, we have 3 time slots available all for “Room 3”.

I would like to have excel, read this chart and ask …”What time will meeting one start on Sunday in Room 1…” then allow the user to input the value. …7:45 am. (this could be a drop down) Then ask “What time will meeting two start on Sunday at Room 1.” It would then need to recognize that there are no more time slots available for on the Sunday for Room 1, that there are no slots for Room 2 or Room 3 on the Sunday , but then realize that Room 4, has 2 more slots. At this points, the sheet should prompt the users for times for this location. This would continue until each time slot has a specific time assigned to it for the specified location for each day.

The number of locations has a maximum of 10 and are assigned by the user further up the sheet.

As I said… I know it is a lot to ask, but I’m not sure on how to move forward…

Thank you.

Excel Workbook
ABCDEFGHIJKLM
129**SlotsRoom 1Room 2Room 3Room 4000000
130**Available**********
131Sunday *42**2******
132Monday *3**3*******
133Tuesday *0**********
134Wednesday *2**2*******
135Thursday *413********
136Friday *0**********
137Saturday *0**********
Calculations
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,122,509
Messages
5,596,558
Members
414,077
Latest member
ammylar5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top