View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default can anyone help with this formula

The answer to your subject line is: yes, someone can help.

To get the help you need, all you have to do is ask an understandable
question. The easier your question is to understand, the quicker and more
accurate the answer.

The most effective way to get the answer you need is:
-- Format your post so it can be read (eg, proper grammar and punctuation)
-- Identify the problem you have. Saying "might have" provides no direction.
You need to identify what result you want when the input is 2 and when it is
4.
-- Provide an example. Show the inputs to the example, and the result you
are looking for.

Regards,
Fred.

"Mike" wrote in message
...
column AP = LINE that is running production some lines have 2 people &
some
have 1 so for instance i MIGHT HAVE AP6 witch might be 2 OR 4 = hours
worked
1 person ON THIS LINE so it will = to 2 or 4 hours witch works Then i have
AP13 WITCH MIGHT BE 2 or 4 = hours actually worked but there is 2 people
on
this so AP13 reads 4 or 8 pending if they worked 2 hours or 4 hours
because
there is 2 people on this line Now in column AS6:AS37 I PUT IN CLOCK# FOR
indirect labour say if 2 clock# entered i want to calculate AP column
actual
hours worked times AS column indirect labour at time & half I want total
hours of indirect hours in cell AS38 Remember AS13 MIGHT READ 4 because of
2
people on & actual overtime hours is 2 so 2 indirect clock # should read 6
overtime hours