Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I assign a numeric value to a letter
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I assign a numeric value to a letter
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 On Nov 28, 9:33*am, IASG <IASG @discussions.microsoft.com wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I assign a numeric value to a letter
You would probably need to create a UDF to reference the letters in formulae. -- 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=34861 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign a letter to a number and then retrive | Excel Worksheet Functions | |||
How to assign a formula to a letter? | Excel Worksheet Functions | |||
How do I assign a letter value to a range of data? | Excel Discussion (Misc queries) | |||
How do I assign numerical values to a letter? Ex: A = 4, B=3, etc | Excel Worksheet Functions | |||
How do I assign a numeric value to a text letter | Excel Discussion (Misc queries) |