B
bajanswing
Hello
I need help with a formula I'm using that is not functioning the way I need
it to. I am trying to represent employee hours worked, sick, vacation with a
letter such as "r"= 7.5 or 8 hrs, "u" =11 hrs, "s"= 8 or 11 hrs, "v"=8 or 11
etc....
I have three different shifts of hours the first one totals 81.25 (based on
bi-monthy average) the second and the third is 86.67. one of the shifts has
a modified schedule which usually consist of 11 days. This is where my
problem comes in. Because the fact that I have two shifts with the same
amount of scheduled hours, my formula will not calculate the proper number of
sick, vacation or other days I need to represent.
Now this is how it is working right now:
M7=COUNTIF($AP7:BT7, "S")*IF(E7=81.25,7.5,IF(E7=86.67,8,IF(E7=83.42,11)))
*note: I did not mention a shift with 83.42, that is because I don't have
one and need that to represent "11" hrs. Which means the above formula has
to also read 86.67 in the final part of the equation. How do I do this? Do
I need to represent it with another "countif" statement or an "if"?
How does 86.67 =8hr and/or 11 hrs without me having to manually adjust it
each time? Is there a way to colour code the selection in order for it to
tell the difference between the two and yet come up with the right answer?
HELP please!!! This has been plaquing me for sometime now.
I need help with a formula I'm using that is not functioning the way I need
it to. I am trying to represent employee hours worked, sick, vacation with a
letter such as "r"= 7.5 or 8 hrs, "u" =11 hrs, "s"= 8 or 11 hrs, "v"=8 or 11
etc....
I have three different shifts of hours the first one totals 81.25 (based on
bi-monthy average) the second and the third is 86.67. one of the shifts has
a modified schedule which usually consist of 11 days. This is where my
problem comes in. Because the fact that I have two shifts with the same
amount of scheduled hours, my formula will not calculate the proper number of
sick, vacation or other days I need to represent.
Now this is how it is working right now:
M7=COUNTIF($AP7:BT7, "S")*IF(E7=81.25,7.5,IF(E7=86.67,8,IF(E7=83.42,11)))
*note: I did not mention a shift with 83.42, that is because I don't have
one and need that to represent "11" hrs. Which means the above formula has
to also read 86.67 in the final part of the equation. How do I do this? Do
I need to represent it with another "countif" statement or an "if"?
How does 86.67 =8hr and/or 11 hrs without me having to manually adjust it
each time? Is there a way to colour code the selection in order for it to
tell the difference between the two and yet come up with the right answer?
HELP please!!! This has been plaquing me for sometime now.