Desperately need help with a formula

[KellyC]

I am working on a Paid Time Off calendar for the employees of our company and
would like to have a formula to calculate ONLY how much PTO has been taken.
I currently have a formula that takes the 2008 carry over (AR2) adds the
accrual rate (AU1) multiplied by two (number of times paid each month) and
then deducts the number of hours taken each month. I have separate cells for
the number of hours taken off, the absence code (i.e. "p" for PTO, "b" for
Bereavement, etc.), accrual rate and 2008 carry over.

The formula I would like to create would only subtract those absence code
cells with a "p". See current formula below:

=SUM(AR2,AU1*2)-K22-C24-E24-G24-I24-K24-C26-E26-G26-I26-K26-E28-G28-I28-K28-C30-E30-G30-I30-K30

 

[NBVC]

Can you give better description of your setup?

HOW TO GET FURTHER HELP WITH A WORKBOO
For further help with it why not join our forums (shown i
the link below) it's completely free, if you do join you will have th
opportunity to add attachments to your posts so you can add workbooks t
better illustrate your problems and get help directly with them. Also i
you do join please post in this thread (link found below) so that peopl
who have been following or helping with this query can continue to d
so. :

 

[KellyC]

In the formula (AR2 is the 2008 carry over, AU1 is the accrual rate * 2 for
the number of times the accrual happens in the month)- K22-C24, etc, are the
cells of the actual days of the month and this is where I would enter the
number of hours taken off.

I have each month listed; with each day within the month and each day of the
month has two cells; one for the hours taken within that day and one cell for
the absence code. Does that make sense?

 

[KellyC]

This particular formula is for January.