software

Hi,

Here is what I am trying to do:

I have a spreadsheet that keeps track of employees vacation and sick
time.

The spreadsheet is formatted to column A is the employee name, columns
B - AB are days of the month.

I would like to have the manager be able to enter in the time off as
either S8 or V8 (8 representing the number of hours off the employee
had S = sick V = vacation).

I would like Column AC to then calcuate the total sick hours and AD to
calcuate the total of vacation hours.

I played around with a few formulas but could not figure out a way to
do it. Is there a way to have this done? What is the correct formula?

Thank you very kindly for the input!See response in public.excel

--

HTH

RP
(remove nothere from the email address if mailing direct)gt; wrote in message ups.com...
gt; Hi,
gt;
gt; Here is what I am trying to do:
gt;
gt; I have a spreadsheet that keeps track of employees vacation and sick
gt; time.
gt;
gt; The spreadsheet is formatted to column A is the employee name, columns
gt; B - AB are days of the month.
gt;
gt; I would like to have the manager be able to enter in the time off as
gt; either S8 or V8 (8 representing the number of hours off the employee
gt; had S = sick V = vacation).
gt;
gt; I would like Column AC to then calcuate the total sick hours and AD to
gt; calcuate the total of vacation hours.
gt;
gt; I played around with a few formulas but could not figure out a way to
gt; do it. Is there a way to have this done? What is the correct formula?
gt;
gt; Thank you very kindly for the input!
gt;
On 4 Jan 2006 13:36:24 -0800, wrote:

gt;Hi,
gt;
gt;Here is what I am trying to do:
gt;
gt;I have a spreadsheet that keeps track of employees vacation and sick
gt;time.
gt;
gt;The spreadsheet is formatted to column A is the employee name, columns
gt;B - AB are days of the month.
gt;
gt;I would like to have the manager be able to enter in the time off as
gt;either S8 or V8 (8 representing the number of hours off the employee
gt;had S = sick V = vacation).
gt;
gt;I would like Column AC to then calcuate the total sick hours and AD to
gt;calcuate the total of vacation hours.
gt;
gt;I played around with a few formulas but could not figure out a way to
gt;do it. Is there a way to have this done? What is the correct formula?
gt;
gt;Thank you very kindly for the input!Array-enter:

=SUM(--IF(LEFT(B24:AB24,1)=quot;Vquot;,REPLACE(B24:AB24,1,1,quot;quot;)))

To array enter a formula, hold down lt;ctrlgt;lt;shiftgt; while hitting lt;entergt;. Excel
will place braces {...} around the formula.

If the number of hours will always be 8, then the formula can be simplified:

=COUNTIF(B24:AB24,quot;V*quot;)*8
--ron