I am making a payroll program which consists of differant worksheets.
On one worksheet called "DAILY LOG', I log men in at differant stations, (C, meaning he is at central station, SS meaning he is at a South Station. On this worksheet those letters mean nothing more...nothing less.
however, on this worksheet, the letter S, means he is off sick and puts a value of 11.2 hrs. in the sickleave cell.
if I enter a number, forinstance 12, that puts 12 hrs. in the cell or column for 12 hrs. OVERTIME.
Now, on another worksheet, I refer to a certain column to read what men were on duty.
If this cell corresponds to a man that was working at the Central fire station, I want to enter the value of 24 in this cell. (SS would mean he is on duty at the South Station and enter a value of 24 in the cell.
I am using the Formula: =COUNTIF('Daily Log'!D6,"C")*24
this works, butI also would like to add "SS"to it, so that if it see's a C or a SS it will add the number 24 to the cell in second worksheet.
Does this make any clearer sense as to what I am trying to do???
On one worksheet called "DAILY LOG', I log men in at differant stations, (C, meaning he is at central station, SS meaning he is at a South Station. On this worksheet those letters mean nothing more...nothing less.
however, on this worksheet, the letter S, means he is off sick and puts a value of 11.2 hrs. in the sickleave cell.
if I enter a number, forinstance 12, that puts 12 hrs. in the cell or column for 12 hrs. OVERTIME.
Now, on another worksheet, I refer to a certain column to read what men were on duty.
If this cell corresponds to a man that was working at the Central fire station, I want to enter the value of 24 in this cell. (SS would mean he is on duty at the South Station and enter a value of 24 in the cell.
I am using the Formula: =COUNTIF('Daily Log'!D6,"C")*24
this works, butI also would like to add "SS"to it, so that if it see's a C or a SS it will add the number 24 to the cell in second worksheet.
Does this make any clearer sense as to what I am trying to do???
