Thanks for responding .... Here is my requirement. We get tasks which need
to be completed in particular time span and are assigned in our team . This
is stored in our database. we pull that in one sheet

Name Taskcode startTime EndTime
abc 123 7/20/08 8:30 7/20/08 9:30
xyz 234 7/20/08 8:00 7/20/08 10:30
abc 345 7/20/08 11:00 7/20/08 12:00
xyz 456 7/20/08 10:30 7/20/08 11:30

From the above sheet , I know abc is busy from 8:30 -9.30 and 11.00-12.00 in
a day and if at all have to assign work i can do it in either 9.30 to 11.00
or after 12.00.
In my master sheet I would like it this way..

Time\Employee abc xyz
7/20/08 8:00 --
7/20/08 8:30 -- ---
7/20/08 9:00 --- ---
7/20/08 9:30 ----
7/20/08 10:00 234
7/20/08 10.30 456
7/20/08 11:00 --- 456
7/20/08 11.30 ---
7/20/08 12:00

by looking at my master sheet I can easily say when abc if free. I either
want it to be marked with symbol or taskname or any particular color for each
employee...

Please let me know if this is possible in Excel. hope it is clear..



"Dave Eade" wrote:

I think you need to be more specific in what you are trying to achieve.

It sounds to me link you should be using something like MS Project.

Do you manually assign the work to each employee for each hour ?
--
Dave Eade
EPCS Ltd
www.EPCS.me.uk



"Sri" wrote:

Hi ...

I have 4 columns in one sheet with emp name, project name , start time and
end time per day.
In another sheet I have time (column) and emp name (row).... I need to color
differently for each employee based on the number of hours of work in order
to identify easily which hour we can assign a work or meeting .. Is graph a
good idea?

Pls help.. Thanks in advance !!!!!!!!