Populate Calendar w/multiple dates/times

Hello, I have hit a stumbling block, and hope this can be completed.

I can get the calendar populated for the first start/end times, but need to enter multiple dates/times for the same item.
The only thing I can think of is adding more rows, and just keep going down the column instead of across the rows.
(would prefer to go across the rows - Still not sure of how many I would need)

Thanks!
Chris

Nothing?
Is this not do-able? VB Code?

This could be done with a few formulae.

Are you only ever going to have one event at any one time slot for each day?

I would suggest that instead of having the complete year shown in the Schedule sheet (365 + columns), you only have one month shown, and have a drop-down list whereby you can select the month of interest - the calendar display would change automatically.

In terms of data entry, it would be simpler (for you) to just have one column for start date/time and one column for end date/time (or you could replace this with a Duration column), and to have multiple entries in different months going down the sheet.

Hope this helps.

Pete

That's what I thought.
Think I'll put this project to rest.

Thanks,

Ah well, I did make a start in laying this out so that you have only one month displayed, using the date in B3 to control the month to display, and starting with Saturday going across to Sunday 6 weeks later (which is the maximum number of days you will need).

I'm going out soon, but I could pick this up again later if you want to progress with it - you need to answer my question about the time slots.

Pete

Wow, okay. Thanks!
The boss would like to see this progress so...

"Are you only ever going to have one event at any one time slot for each day?" Yes, only one event per time slot.
And I just found out the "data" sheet will contain about 350/370 items (Under Title)

I've been playing a little more on the data page.
Please see attachment.

What I have come up with is to 'ADD' minutes to the date to make things a little easier...
But the new problem is the Coffee breaks and lunch break.
Is there any formula what can detect this time, and 'skip' coffee and lunch breaks when adding the time?

I'm actually making progress here!
A couple of things I would like to work out...

If the number of periods extends past 4:00pm, add one day then continue...

---

LOL Its kinda convoluted, but its working...
(I'm sure this could be simplified as well... once I get the formulas worked out, I'll condense what I can)

That formula works! Thank you!

I've found a glitch in my own code now.
Seems that if a course spans over the coffee break and into lunch, the 10 minutes
for the coffee break isn't added in... For example:
If a course runs 240 minutes, the 10 minutes isn't added on after lunch.

Suggestions?
And THANKS!

Quick test seems great! thank you!
(No time to test right now... a tomorrow task!)

THANKS!

Hello, Pete mentioned being able to display just one month on the calendar instead of the entire year.
Would you mind? (I really have no clue on how to pull that one off!)

Thanks!

P.S. Would only having one month show speed up calculations?
(My work computer is super slow at calculations)

Thank you.
Really appreciate your help with this project.
It's working, and I think the calculations are slowing down due to the number of rows held within the Name Manager...

I've been off the board for a few weeks, but here is the file I worked on originally, to show you how you can set your file up to display only one month. Just change the date in B3 to see the effect.

Note that this is based on the first file you posted, not on any subsequent ones.

Hope this helps.

Pete

Thanks Pete!

For the curious... here is the 'mostly' finished file... Still tweaking it here and there...
There are quirks in it, but I can make it all work!

Thanks again to everyone!

(The dates are just random and used for testing...)