not being a master computer whizz, i have so far only been putting in manual figures but i was wondering if there was a way for the computer to do it for me

the problems are as follows:

i have set the conditioning format of the spreadsheet to put a "H" if someone is on holiday, a "S" if they are off sick and an "X" if they are not working for any other reason

these get tallied up and give you an end of the year figure for all sorts of stuff and are updated in a different spreadsheet that i don't have access to alter but can view so that i can make things right in there, it's too complicated for me to explain but it all works

what i need to do is to make sure that if i put "H" into the spreadsheet, not only does it tally up elsewhere, it also adds 9.5 (the hours that they get paid for normally) onto some other bit of the spreadsheet, rather than tally up the holidays acrued over the months/year and then start adding them up into the totals column

firstly, is this possible?

secondly, can someone show me how to do it if the answer to question 1 is yes?

thank you