Master Schedule separated into individual tabs, totally minutes

**JLYGirl** · 06-21-2013, 12:29 AM

Hi,

I'm a novice at Excel, and I think this question has been asked...but I can't find the thread. Maybe I'm typing in the wrong search words.

I am scheduling Gym and Music classes at a very large school for over 50 classes. I have created master schedules, and would like to create individual schedules for each class by creating new worksheets for each class. (Please see attached example). In the example, the schedules are in a pattern, but the real schedule is quite random.

Music-Gym Schedule Example.xlsx

The main reason for separating the individual class worksheet is to add up the total number of minutes of gym and music. The periods of the day are different (40, 30, 50, 60 minutes), but each class needs a specific total number of minutes. By separating them out, I was hoping it would make it easier to add and avoid mistakes. If there is another way to sum up the total number of minutes each class has Gym and Music, that would work out too.

Thank you.

Edit: Oops...the title should say "totaling" minutes

**FDibbins** · 06-21-2013, 12:37 AM

Hi and welcome to the forum

Where does the 1A, 2A, 3A, 1B etc come from?

Im not sure from your description and file what your expected outcome would be, and how you would arrive that that?

Edit: and also, I know why Im up at this time of night - I work 2nd shift...but what on earth are you doing up this late, isnt tomorrow a school day lol?

**JLYGirl** · 06-21-2013, 12:54 AM

Sorry, I wasn't very clear...I blame it on brain being dead from being up late

It's year-end, so everything's due - report cards, planning graduation, scheduling for next year...but summer's in sight, so a few more crazy weeks and then I'll sleep.

1A, 2A, 3A, etc are the different classes that would to to Gym and Music. Our school works on a 10-day cycle (Row 1) and Column 1 shows the Periods (and the length of each period in minutes).

My end goal is to total up the number of minutes each class has for Gym and Music. I was thinking that if I could separate the master schedule into the different classes, I could then manually add up the minutes. So in the example, I can quickly add up that Class 1A has 150 minutes of Gym and 200 minutes of Music.

However, if there is a way to add up the total minutes each class has Gym and Music, without separating the schedule, I'm up for that too. It would actually save me a lot of time, as we actually have over 50 classes at our school.

Thanks for your help!

**FDibbins** · 06-21-2013, 01:11 AM

Not sure if this is what you are after, or if it will get you headed in the right direction? Take a look at the attched

**JLYGirl** · 06-21-2013, 01:37 AM

Originally Posted by FDibbins

Not sure if this is what you are after, or if it will get you headed in the right direction? Take a look at the attched

Thank you! That looks great, and it looks like it's going to work! When I get to school tomorrow, I'll plug in the actually times and classes into the spreadsheet. Thank you again!