Funky Function.

[Raymond]

I downloaded a template called shift schedule from Microsoft:
http://office.microsoft.com/en-us/templates/TC062561761033.aspx?CategoryID=CT063469961033

The template is to schedule the work hours for employees. The hours are
listed in row. The row below are input rows in which I suppose to enter any
text in a cell. On the far left most column cells are employee names. On
the far right column cells are the total of hours add together for each
employess. Each time I enter text from a single cell in the data entry
rows, a value of 1 will be added to the total hours. However, the function
have one minor flaw is that it adds one extra hour for the total hours
worked for each employee. I need help on a function that would fix this
flaw, as well as any suggestion. I asked many question in this and other
newsgroups before about this template, but unable to fix the problem,
instead new problems arrives with the fixes.

Many Thanks.

 

[Myrna Larson]

Whatever the formula is that calculates the number of hours, tack a -1 on the
end of it.

 

[Raymond]

But if no hour or text is entered, the total hours cells will return a -1
value.

 

[Myrna Larson]

So.... you surround your formula with an IF function that prints whatever you
want if you don't have all of the data. The -1 is appended to the part that is
calculated when you DO have all data.