Hey Jon,

That's the name! It was on the tip of my tongue but kept coming out
wrong. Thanks.

As for the links, they are excellent. However, they are way beyond my
capabilities. Do you do small projects for a reasonable fee? If so,
please contact me directly at exreply[at]i-m-p.net.

Thanks.

-Minitman

On Mon, 19 Dec 2005 18:29:30 -0500, "Jon Peltier"
wrote:

Looks to me like a Gantt chart. Here are some tips:

http://pubs.logicalexpressions.com/P...cle.asp?ID=343
http://peltiertech.com/Excel/Charts/GanttChart.html
http://peltiertech.com/Excel/Charts/GanttLinks.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Minitman" wrote in message
.. .
Greeting,

I would like to build a chart for scheduling workers. What I would
like is a chart with time across the top and workers down the left
side. There are a number of jobs to be done each day. These jobs
range from 1 to 20 hours, most are 2 to 4 hours.

The time is broken down by 12 minute intervals.

I need to assign each worker as many jobs as they can handle.

I saw a chart that was set up with time across the and workers down
the side and the jobs are blocked off in the time the job took, in the
row of the worker. Each worker is blocking off from 1 to 4 jobs a
day. Something like this:

8 9 10 11 12 1 2 3 4 5
Time |----|----|----|----|----|----|----|----|----|
Worker A |----|< 3 |--< 8 |--< 9 -|
Worker B |< 1 |--< 5 |----|----|
Worker C |----|----|< 2 |----|

Job 1 is 4 hours in the AM
Job 2 is 6 hours starting at 10:00 AM
Job 3 is 2 hours any time
Job 4 Cancelled
Job 5 is 2.5 hours any time
Job 6 Cancelled
Job 7 Cancelled
Job 8 is 2.5 any time
Job 9 is 2 hours in the afternoon

My first question is: What is this kind of chart called?
And my next question is: How do I create one?

Anyone have any ideas?

Any help would be appreciated/

TIA

-Minitman