Oops...sorry, the example got cut off...It should look more like this:


My spreadsheet looks something like this: (The blank space indicates a lunch
break)
Name 7:30 - 8:00 - 8:30 - 9:00 - 9:30 - 10:00 - 10:30 - 11:00
Bob 1 1 1 1 1
1
Stan 1 1 1
1