Re: Schedule

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Here's a sample file that demonstrates this.

http://cjoint.com/?kseRvlVD6X

Check the check box and you'll get a Gantt chart.

--
Biff
Microsoft Excel MVP


"Brandon" <Brandon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BF897217-23F5-4988-9B8C-5780F66FA04D@xxxxxxxxxxxxxxxx
I'm making a work schedule in excel but I would like to make a graph or a
table showing we the employee works

Here is how the data looks like:
start end
name 7 am 5 pm

For the table would look like this:
7 am 8 am 9 am 10 am
name x x x x


I have tried if and or functions but it doesn't work.


Is there away to graph this or use functions to make this happen?

Thanks
Brandon


.

Relevant Pages

  • RE: Splitting Comma delimited list
    ... I have nothing to gain by not showing you all my code, ... <option value="BCS Employee"> ... Financial Benefits <option value="Global Pulse Survey"> Global Pulse ... Career"> Your Career ...
    (perl.beginners)
  • Re: Lookup based on a date being between a range
    ... Microsoft Excel MVP ... I want to lookup the correct hourly rate of an employee in a table. ... I want to lookup the correct Rate for Mary based on the date she ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Finding a match within a match
    ... Microsoft Excel MVP ... summary pay period sheet for 1/5/08 for certain lines. ... are same for each employee (Fred and Tom both have gross wages) Rows ...
    (microsoft.public.excel.misc)
  • Re: trying to use Indirect function
    ... Valko" wrote: ... Microsoft Excel MVP ... worksheet in the file for each employee, with the name of the worksheet ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Gantt serie with different colors
    ... > I have to build a Gantt chart. ... On X axis I've obviously the time. ... > each employee is busy. ... Avoids flicker. ...
    (comp.lang.pascal.delphi.misc)