Problem with Formula in Time Sheet

[sportsys]

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

[teylyn]

Hi,

seems that you need to understand the IF function syntax a bit better.


The syntax of the IF goes like this:

=IF(<condition>, <do when true>, <do when false>)

where

<condition> is a test like A1=5 or B17>A16
<do when true> is what the formula should calculate when the condition is met,
<do when false> is what the formula should calulate or return when the condition is not met.

In your IF statement, you do not have any condition, for example

IF(,"V","0")

Now, looking at your spreadsheet, I don't seem to find any references to "V" or "S" other than in your IF statements.

If V or S to indicate vacation or sick leave, where will that be entered? How will Excel know which days are V or S? Maybe you need another two columns next to the REG, one where users enter hours for vacation and one where they enter hours for sick leave. Then you can all add it up in the totals.

See attached for a starting point.

Oh, and when you post a new version of your sheet, please include just a couple of time sheets. no need for the whole enchilada, that just eats up bandwidth.

cheers