How do I assign a numeric value to a letter

I

IASG

I am creating a work schedule and I need to asign letters to the different
shifts (start and end times) I also have to asign a numeric value to the
letter to denote the duration of the shift in hours. ie
Shift A 2300 -0800 = 9 hours therefore A=9
Shift A1 0200-0800 = 6 hours therefore A1=6
At the end of the schedule i should be able to sum up how many total hours
were worked per month, how many hours each shift worked per month.....
Thank You
GB
 
P

Pete_UK

Just set up a two-column table somewhere on your sheet (eg in columns
X and Y) like this:

A 9
A1 6
etc.

then if you have your shift code in cell A1, you can use this formula:

=VLOOKUP(A1,X:Y,2,0)

to get the appropriate number.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Calculations over a week 5
Calculate the duration between the end time and start time of anot 4
How do I allow for multiple values in VLOOKUP? 3
Multi conditional UDF 1
Using COUNTIF and VLOOKUP with upper and lower case letters 5
how do I calculate a week days hours with the 24hour clock 5
Excel: I want to assign numeric values to letters in a speradsheet 3
CountA or DcountA, that is the question?? 1

Top