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" wrote in message
...
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