Hi Viv,

I've done exactly that in Excel. I put the names of the rooms in Column A,
starting in Row 2, and the times of day in Row 1, starting in Column B. Now
you can enter the name of the event or the person into the cells that show
the intersection of the room and the range of times.

If you have just a few room reservations to account for, and don't need to
schedule way out into the future, copy that sheet several times. Now it's
convenient to change the name of each sheet so that it displays a different
date or day-of-week.

If you have an even more slightly complicated situation (for example, if you
need to identify specific resources, other than the room itself, that need
to be scheduled, or you need to schedule well into the future, or you need
to specify a bunch of other information such as account numbers or food
service or people's names) then you need to get a database involved. But if
so, continue to use Excel for the data entry because the worksheet is so
much more flexible as to layout and appearance than is a database's data
sheet.

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"Viv_Martin" wrote in message
...
How can I set-up a multiple room scheduler with15 minute increments in
Excel?