Schedule

[Brandon]

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

 

[T. Valko]

Here's a sample file that demonstrates this.

http://cjoint.com/?kseRvlVD6X

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

 

[Brandon]

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]

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.

 

[Brandon]

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

 

[Brandon]

Let me explain a little more:

When someone is scheduled 10 pm to 7 am it doesn't mark it on the graphic.


Is there away to get to work?

Thanks