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

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

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

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

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

Let me explain a little mo

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


"Brandon" wrote:

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