Schedule

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
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
 
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
 
Back
Top