Greetings,

I had to develop an Excel spreadsheet that closely resembles your
requirements. It was not the easiest thing to do, but this forum and
its archives helped me create what I wanted.

This is used for primarily for conferences and symposiums to plan and
schedule speaker times, workshop, technical sessions and demonstrations
over a 2 to 5 day period. Also, the spreadsheets showed the planning
activities over several months leading up to the event.

A spreadsheet had each of the days broken down in 15 or 20 minute
intervals. A GANTT style chart that showed the specific speaker name
and time. This was to ensure that if a speaker was presenting more than
one paper, I did not schedule him to speak in two different rooms at
the same time. A GANTT style chart that outlined the several months of
planning activities. This gave the overall big picture of things
happening. It is definetly not a replacement for Microsoft Project, but
it does the job.

There are still a few quirky things that I have to do when using the
above as a template on new conferences, but I've learned to live with
them for now.

All this was down via the information from this forum, its archives and
several excellent books on Excel. And most of all persistance.

Hopes this helps.

RichardG