Is all the work for the same amount of time. Are some scheduled tasks
15 minutes and others 2 hours?

The best method is two use more tha one sheet. One summary sheet and
another to actually keep the time slots. I would make a wroksheet with
all the time slots like this


1/1/10 9:00 AM
1/1/10 9:15 AM
1/1/10 9:30 AM
...

1/1/10 4:30 PM
1/1/10 4:45 PM
1/1/10 5:00 PM
1/2/10 9:00 AM
1/2/10 9:30 AM
...

Then in the adjacent column put the name of the appointment to indicate
that the slot has been taken. You can make also make a calendar like
spreadsheet to summarize the data but the actuall appointments slots are
on the sheet above. If you need a 2 hour slot the macro can look for
that period of time that is available.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=147244