If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
adding text
I am building a work schedule. I have different text and numerical codes for
shifts (ob1, ob2, n, sac, 9-5, 1, AND ER) I want the schedule to add only the text I have in parenthesis. I want this to be a numerical value. I want it to ignore my day off code and Holiday Time(do, ht) Also after this I want another cell to show 12- the answer I received from the added days above. I do not want to change the format of my schedule. It has been used for years. I am using Microsoft Excel 2003 98xp pro -- Jay Taylor |
#2
|
|||
|
|||
adding text
I'm not clear on what you want.
First you say you want the schedule to add only the text in parens Then you say you want the entry to be a numeric value. The text in parents is not numeric. Do you want to convert it to numeric somehow? A piece of this puzzle is missing. We'll get to the 12 later. "Jay Taylor" wrote in message ... I am building a work schedule. I have different text and numerical codes for shifts (ob1, ob2, n, sac, 9-5, 1, AND ER) I want the schedule to add only the text I have in parenthesis. I want this to be a numerical value. I want it to ignore my day off code and Holiday Time(do, ht) Also after this I want another cell to show 12- the answer I received from the added days above. I do not want to change the format of my schedule. It has been used for years. I am using Microsoft Excel 2003 98xp pro -- Jay Taylor |
#3
|
|||
|
|||
adding text
ob1 & ob2 needs to equal 12, n,sac,9-5,1,and er needs to equal 8.
1 2 3 4 5 worker 1 ob1 9-5 1 ob2 n should equal 48 worker 2 n 1 9-5 ob1 ob2 should equal 48 -- Jay Taylor "Barb Reinhardt" wrote: I'm not clear on what you want. First you say you want the schedule to add only the text in parens Then you say you want the entry to be a numeric value. The text in parents is not numeric. Do you want to convert it to numeric somehow? A piece of this puzzle is missing. We'll get to the 12 later. "Jay Taylor" wrote in message ... I am building a work schedule. I have different text and numerical codes for shifts (ob1, ob2, n, sac, 9-5, 1, AND ER) I want the schedule to add only the text I have in parenthesis. I want this to be a numerical value. I want it to ignore my day off code and Holiday Time(do, ht) Also after this I want another cell to show 12- the answer I received from the added days above. I do not want to change the format of my schedule. It has been used for years. I am using Microsoft Excel 2003 98xp pro -- Jay Taylor |
#4
|
|||
|
|||
adding text
Hi Jay
With your data in A1:F3, enter in cell H2 =SUMPRODUCT(--(B1:F1"")*8)+SUMPRODUCT(--(LEFT(B1:F1,2)="ob")*4) and copy down Regards Roger Govier Jay Taylor wrote: ob1 & ob2 needs to equal 12, n,sac,9-5,1,and er needs to equal 8. 1 2 3 4 5 worker 1 ob1 9-5 1 ob2 n should equal 48 worker 2 n 1 9-5 ob1 ob2 should equal 48 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Is Access even the right idea? | BMB | New Users | 19 | November 21st, 2005 08:01 PM |
Need Subforms? | AccessRookie | Using Forms | 7 | April 8th, 2005 09:30 AM |
Change font of part of text | John | Powerpoint | 7 | March 15th, 2005 10:10 AM |
Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |
Concatenatd fields in a query for a searching form | Marc | Running & Setting Up Queries | 8 | October 19th, 2004 08:49 PM |