Please Help

Hello and thank you to all that answer questions for us newbies. My question
is, I am now in charge to make employee schedules. What i would like to do
is, make a schedule with the employee names on the left column, the month
we're in in the upper-left corner and the dates on that same row. Now, my
question is: Is there anyway to give, for example 8-12 and 2-7:30, a letter
equivalent. Such as, D= 8-12 and 2-7:30 OR E= 1:30 - Close. I want to make my
schedule look like this: (example)

MARCH MONDAY 16 TUESDAY 17

BOB D E

JEFF E D

Where, D and E will automatically be replaced with the times. Now, if this
isn't possible in Excel, do you recommend a program to use? Thank you for
your time.

If you want to enter the letter in a cell and that cell convert the
letter to a time you are going to need to use VBA, right click the
workcheet tab and choose view code then paste this in, change the range
to suit:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub
If Not Intersect(Target, Range("B2:Z100")) Is Nothing Then
Select Case Target
Case Is = "C"
Target = "8-12"
Case Is = "D"
Target = "2-7:30"
Case Is = "E"
Target = "1:30 - Close"
End Select
End If
End Sub

marine247;260278 Wrote:
Hello and thank you to all that answer questions for us newbies. My
question
is, I am now in charge to make employee schedules. What i would like to
do
is, make a schedule with the employee names on the left column, the
month
we're in in the upper-left corner and the dates on that same row. Now,
my
question is: Is there anyway to give, for example 8-12 and 2-7:30, a
letter
equivalent. Such as, D= 8-12 and 2-7:30 OR E= 1:30 - Close. I want to
make my
schedule look like this: (example)

MARCH MONDAY 16 TUESDAY 17

BOB D E

JEFF E D

Where, D and E will automatically be replaced with the times. Now, if
this
isn't possible in Excel, do you recommend a program to use? Thank you
for
your time.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=72641

Now, I sincerely appreciate the help but, how do i get to that screen on
Excel 2007? I mean, I am as new of a newbie to say the least. Sorry.

"Simon Lloyd" wrote:


If you want to enter the letter in a cell and that cell convert the
letter to a time you are going to need to use VBA, right click the
workcheet tab and choose view code then paste this in, change the range
to suit:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub
If Not Intersect(Target, Range("B2:Z100")) Is Nothing Then
Select Case Target
Case Is = "C"
Target = "8-12"
Case Is = "D"
Target = "2-7:30"
Case Is = "E"
Target = "1:30 - Close"
End Select
End If
End Sub

marine247;260278 Wrote:
Hello and thank you to all that answer questions for us newbies. My
question
is, I am now in charge to make employee schedules. What i would like to
do
is, make a schedule with the employee names on the left column, the
month
we're in in the upper-left corner and the dates on that same row. Now,
my
question is: Is there anyway to give, for example 8-12 and 2-7:30, a
letter
equivalent. Such as, D= 8-12 and 2-7:30 OR E= 1:30 - Close. I want to
make my
schedule look like this: (example)

MARCH MONDAY 16 TUESDAY 17

BOB D E

JEFF E D

Where, D and E will automatically be replaced with the times. Now, if
this
isn't possible in Excel, do you recommend a program to use? Thank you
for
your time.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=72641

Ok. I found the VBA thing. Thank you very much

"Simon Lloyd" wrote:


If you want to enter the letter in a cell and that cell convert the
letter to a time you are going to need to use VBA, right click the
workcheet tab and choose view code then paste this in, change the range
to suit:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub
If Not Intersect(Target, Range("B2:Z100")) Is Nothing Then
Select Case Target
Case Is = "C"
Target = "8-12"
Case Is = "D"
Target = "2-7:30"
Case Is = "E"
Target = "1:30 - Close"
End Select
End If
End Sub

marine247;260278 Wrote:
Hello and thank you to all that answer questions for us newbies. My
question
is, I am now in charge to make employee schedules. What i would like to
do
is, make a schedule with the employee names on the left column, the
month
we're in in the upper-left corner and the dates on that same row. Now,
my
question is: Is there anyway to give, for example 8-12 and 2-7:30, a
letter
equivalent. Such as, D= 8-12 and 2-7:30 OR E= 1:30 - Close. I want to
make my
schedule look like this: (example)

MARCH MONDAY 16 TUESDAY 17

BOB D E

JEFF E D

Where, D and E will automatically be replaced with the times. Now, if
this
isn't possible in Excel, do you recommend a program to use? Thank you
for
your time.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=72641

Hi,

My question is what exactly do you want to display in the cells? D= 8-12 and
2-7:30
Remember that "8-12 and 2-7:30" is not a time, it is text.

You can define names D to be equal to "8-12 and 2-7:30" and then instead of
typing D into the cell you just type =D in.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"marine247" wrote:

Hello and thank you to all that answer questions for us newbies. My question
is, I am now in charge to make employee schedules. What i would like to do
is, make a schedule with the employee names on the left column, the month
we're in in the upper-left corner and the dates on that same row. Now, my
question is: Is there anyway to give, for example 8-12 and 2-7:30, a letter
equivalent. Such as, D= 8-12 and 2-7:30 OR E= 1:30 - Close. I want to make my
schedule look like this: (example)

MARCH MONDAY 16 TUESDAY 17

BOB D E

JEFF E D

Where, D and E will automatically be replaced with the times. Now, if this
isn't possible in Excel, do you recommend a program to use? Thank you for
your time.

Hi,

To name a constant choose Formulas, Define Name and enter D in the Name box
and ="8-12 and 2-7:30" into the Refers to box. repeat for E.

Move to a cell and type =D or =E

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"marine247" wrote:

Now, I sincerely appreciate the help but, how do i get to that screen on
Excel 2007? I mean, I am as new of a newbie to say the least. Sorry.

"Simon Lloyd" wrote:


If you want to enter the letter in a cell and that cell convert the
letter to a time you are going to need to use VBA, right click the
workcheet tab and choose view code then paste this in, change the range
to suit:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub
If Not Intersect(Target, Range("B2:Z100")) Is Nothing Then
Select Case Target
Case Is = "C"
Target = "8-12"
Case Is = "D"
Target = "2-7:30"
Case Is = "E"
Target = "1:30 - Close"
End Select
End If
End Sub

marine247;260278 Wrote:
Hello and thank you to all that answer questions for us newbies. My
question
is, I am now in charge to make employee schedules. What i would like to
do
is, make a schedule with the employee names on the left column, the
month
we're in in the upper-left corner and the dates on that same row. Now,
my
question is: Is there anyway to give, for example 8-12 and 2-7:30, a
letter
equivalent. Such as, D= 8-12 and 2-7:30 OR E= 1:30 - Close. I want to
make my
schedule look like this: (example)

MARCH MONDAY 16 TUESDAY 17

BOB D E

JEFF E D

Where, D and E will automatically be replaced with the times. Now, if
this
isn't possible in Excel, do you recommend a program to use? Thank you
for
your time.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=72641

Mariane, if you are not comfortable with VBA Shane's solution would suit
you best for your situation as changing the times and things you want
displayed will be a lot simpler, also using NAME like that means its
available in every worksheet, whereas the code i supplied specifically
works only with the worksheet it is placed in.

Shane Devenshire;260360 Wrote:
Hi,

To name a constant choose Formulas, Define Name and enter D in the Name
box
and ="8-12 and 2-7:30" into the Refers to box. repeat for E.

Move to a cell and type =D or =E

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"marine247" wrote:

Now, I sincerely appreciate the help but, how do i get to that screen
on
Excel 2007? I mean, I am as new of a newbie to say the least. Sorry.

"Simon Lloyd" wrote:


If you want to enter the letter in a cell and that cell convert the
letter to a time you are going to need to use VBA, right click the
workcheet tab and choose view code then paste this in, change the
range
to suit:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub
If Not Intersect(Target, Range("B2:Z100")) Is Nothing Then
Select Case Target
Case Is = "C"
Target = "8-12"
Case Is = "D"
Target = "2-7:30"
Case Is = "E"
Target = "1:30 - Close"
End Select
End If
End Sub

marine247;260278 Wrote:
Hello and thank you to all that answer questions for us newbies.
My
question
is, I am now in charge to make employee schedules. What i would
like to
do
is, make a schedule with the employee names on the left column,
the
month
we're in in the upper-left corner and the dates on that same row.
Now,
my
question is: Is there anyway to give, for example 8-12 and
2-7:30, a
letter
equivalent. Such as, D= 8-12 and 2-7:30 OR E= 1:30 - Close. I
want to
make my
schedule look like this: (example)

MARCH MONDAY 16 TUESDAY 17

BOB D E

JEFF E D

Where, D and E will automatically be replaced with the times.
Now, if
this
isn't possible in Excel, do you recommend a program to use? Thank
you
for
your time.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' ('The Code Cage' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Please Help - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...ad.php?t=72641)




--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=72641