Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 28th 08, 10:33 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 1
Default 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   Report Post  
Old November 28th 08, 11:33 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default 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   Report Post  
Old November 28th 08, 11:35 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assign a letter to a number and then retrive ppmorise Excel Worksheet Functions 1 December 21st 07 02:05 AM
How to assign a formula to a letter? Judy Excel Worksheet Functions 4 July 18th 07 07:27 PM
How do I assign a letter value to a range of data? clatters69 Excel Discussion (Misc queries) 1 September 16th 06 05:55 PM
How do I assign numerical values to a letter? Ex: A = 4, B=3, etc Bob1023 Excel Worksheet Functions 1 July 26th 06 02:53 AM
How do I assign a numeric value to a text letter Shaun Excel Discussion (Misc queries) 2 September 18th 05 12:24 AM


All times are GMT +1. The time now is 06:38 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017