Excel Byte Calculation
See response in public.excel
--
HTH
RP
(remove nothere from the email address if mailing direct)
wrote in message
ups.com...
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!
|