software

is possible to write a formula to count the number of hours worked in each
dept.
the number of hours worked in each dept can vary from 1 to 7 vice versa.
eg) if a1 is 3 cash 4 stock , i want a2 to return with the value 3 and a3
to return with the value 4 and a2 and if a1 is cash then a2 to return with
the value 8 and if a1 is stock then a3 to reurn with the value 8.

can anyone help

some questions
is the data in a1 exactly like you type ie 3spacequot;cashquot;space4spacequot;stockquot;
a formula can be built to extract the hours to a2 and a3 ,but then i get
lost,what is the logic that says you need 8 =cash and 8 =stock or 8 from 4 3?
--
paul
remove nospam for email addy!
quot;cjquot; wrote:

gt; is possible to write a formula to count the number of hours worked in each
gt; dept.
gt; the number of hours worked in each dept can vary from 1 to 7 vice versa.
gt; eg) if a1 is 3 cash 4 stock , i want a2 to return with the value 3 and a3
gt; to return with the value 4 and a2 and if a1 is cash then a2 to return with
gt; the value 8 and if a1 is stock then a3 to reurn with the value 8.
gt;
gt; can anyone help

no, the data in a1 should read 3cash 4stock and if a1 is quot;cashquot; , i want a2
to return with value of 8 and if a1 is quot;stockquot; , i want a3 to return with
value of 8.

quot;paulquot; wrote:

gt; some questions
gt; is the data in a1 exactly like you type ie 3spacequot;cashquot;space4spacequot;stockquot;
gt; a formula can be built to extract the hours to a2 and a3 ,but then i get
gt; lost,what is the logic that says you need 8 =cash and 8 =stock or 8 from 4 3?
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;cjquot; wrote:
gt;
gt; gt; is possible to write a formula to count the number of hours worked in each
gt; gt; dept.
gt; gt; the number of hours worked in each dept can vary from 1 to 7 vice versa.
gt; gt; eg) if a1 is 3 cash 4 stock , i want a2 to return with the value 3 and a3
gt; gt; to return with the value 4 and a2 and if a1 is cash then a2 to return with
gt; gt; the value 8 and if a1 is stock then a3 to reurn with the value 8.
gt; gt;
gt; gt; can anyone help

aha if 3cash4stock you want a2 to show 3 and a3 to show 4 if a1 is cash a2= 8
if a1 stock a3 8????
--
paul
remove nospam for email addy!
quot;cjquot; wrote:

gt; no, the data in a1 should read 3cash 4stock and if a1 is quot;cashquot; , i want a2
gt; to return with value of 8 and if a1 is quot;stockquot; , i want a3 to return with
gt; value of 8.
gt;
gt; quot;paulquot; wrote:
gt;
gt; gt; some questions
gt; gt; is the data in a1 exactly like you type ie 3spacequot;cashquot;space4spacequot;stockquot;
gt; gt; a formula can be built to extract the hours to a2 and a3 ,but then i get
gt; gt; lost,what is the logic that says you need 8 =cash and 8 =stock or 8 from 4 3?
gt; gt; --
gt; gt; paul
gt; gt; remove nospam for email addy!
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;cjquot; wrote:
gt; gt;
gt; gt; gt; is possible to write a formula to count the number of hours worked in each
gt; gt; gt; dept.
gt; gt; gt; the number of hours worked in each dept can vary from 1 to 7 vice versa.
gt; gt; gt; eg) if a1 is 3 cash 4 stock , i want a2 to return with the value 3 and a3
gt; gt; gt; to return with the value 4 and a2 and if a1 is cash then a2 to return with
gt; gt; gt; the value 8 and if a1 is stock then a3 to reurn with the value 8.
gt; gt; gt;
gt; gt; gt; can anyone help

ahhh I see you started a new thread..
--
paul
remove nospam for email addy!
quot;cjquot; wrote:

gt; no, the data in a1 should read 3cash 4stock and if a1 is quot;cashquot; , i want a2
gt; to return with value of 8 and if a1 is quot;stockquot; , i want a3 to return with
gt; value of 8.
gt;
gt; quot;paulquot; wrote:
gt;
gt; gt; some questions
gt; gt; is the data in a1 exactly like you type ie 3spacequot;cashquot;space4spacequot;stockquot;
gt; gt; a formula can be built to extract the hours to a2 and a3 ,but then i get
gt; gt; lost,what is the logic that says you need 8 =cash and 8 =stock or 8 from 4 3?
gt; gt; --
gt; gt; paul
gt; gt; remove nospam for email addy!
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;cjquot; wrote:
gt; gt;
gt; gt; gt; is possible to write a formula to count the number of hours worked in each
gt; gt; gt; dept.
gt; gt; gt; the number of hours worked in each dept can vary from 1 to 7 vice versa.
gt; gt; gt; eg) if a1 is 3 cash 4 stock , i want a2 to return with the value 3 and a3
gt; gt; gt; to return with the value 4 and a2 and if a1 is cash then a2 to return with
gt; gt; gt; the value 8 and if a1 is stock then a3 to reurn with the value 8.
gt; gt; gt;
gt; gt; gt; can anyone help