This is my first post here, so please bear with me.

I am a basic Excel user. I am attempting to create a worksheet that I will ultimately be able to import into my Outlook Calendar. Here is the basic problem:

I work at an elementary school. They use a 6 day "Specials" calendar...hence, every 6th day, you are in the computer lab or music or PE, for example.

I need to enter this information into my Outlook calendar, without having to enter each "appointment". I am doing this for the two computer labs.

For a more direct look at the problem:

Every 45 minutes a class rotates through each computer lab.
There are basically 60 classrooms (or 60 different teachers).
Every 6th day, a class repeats its schedule.
We are on a 5 day workweek - 8 - 3:30.
We need to be able to exclude holidays, and teacher in-service days.

Any help will be appreciated.

Thank you,

Brenda