Hey that worked but is there away to get the schedule to work in a 24 hr mode.

7am to 7am right now it doesn't work after midnight.


Thanks again


"T. Valko" wrote:

Ok, if the times are 7:00 AM - 11:00 AM and you don't want 11:00 AM to be
"marked" just change the formula.

In B11, where you see this in the formula (2 places):

B$10<=$C2

Change it to (2 places):

B$10<$C2

Then just copy across and down.


--
Biff
Microsoft Excel MVP


"Brandon" wrote in message
...
It works nice but its off an hour.

example
name1 7am 11am

7am 8am 9am 10am 11am 12pm
x x x x x

It needs to be this
7am 8am 9am 10am 11am 12pm
x x x x


Is there away to get this to work like this?


BTW thanks for the file.

"T. Valko" wrote:

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