color representation of employee work hrs

[Sri]

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 !!!!!!!!

 

[Dave Eade]

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 ?

 

[Sri]

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]

It is possible, but the formula you would need to write would be huge, as
you'd have to have an "if" statement for each possible scenario.

What may be easier is in your sheet to first sort the data by date &
employee & start time.

Then your data would display as

abc 123 7/20/08 08:30 07/20/08 09:30
abc 345 7/20/08 11:00 07/20/08 12:00

The alternative may be to use MS Project, although as your already pulling
from a database that may be more involved.

I take it the database is a specific work management tool rather than
something li MS Access? If it's access you may be able to write a report
without actually using Excel.

Hope that helps....

 

[Sri]

Dave,

Sorting is not a problem. But as I said, I need to get the time slot for
each employee when he is free at a glance instead of going thru all the
records and the rquirement is supposed to be in excel...