Problem with Formula in Time Sheet

I am currently tracking staff time in a spreadsheet that covers a two week period - I have a column that calculates overtime, sick leave and vacation.

What I want the "Total" cell to recognize is that it needs to add the hours together as well as recognize "V" for vacation and "S" for Sick (as these are tracked in another cell) so that the end result is a total of OT hours worked.

Here is the forumla so far - it's not working and I need help desperatly - am I asking Excel to perform something it can't?

I9=IF(,"V","0")*IF(,"S","0")*I$10=IF(,"V","0")*IF(,"S","0")*I$11=IF(,"V","0")*IF(,"S","0")*I$12=IF(,"V","0")*IF(,"S","0")*I$13=IF(,"V","0")*IF(,"S","0")*SUM(I9+I10+I11+I12+I13)

I have also attached a copy of the spreadsheet for your reference.

Thanks a bunch to whomever can help - I'm frustrated

Sportsys