I created a rather detailed excel document that we use to sign in and out of
on a daily basis. It tracks our overtime, and total hours done, etc.

I have been asked to add a colum. We would like that IF we put a "s" for
sick, it will show "off" in the total colum (or zero if it's complicated),
and IF they put an "h" for Holiday it will put an 8 in that Total colum next
to.

I can't seem to get my head around how to do this.

Thank you,

If A1="s" or "h", then in your total column:

IF(A1="s","Off",IF(A1="h",8,total-calculation)

total-Calculation is the formula to calculate your total hours.

Does this help?

"Wyl" wrote:

I created a rather detailed excel document that we use to sign in and out of
on a daily basis. It tracks our overtime, and total hours done, etc.

I have been asked to add a colum. We would like that IF we put a "s" for
sick, it will show "off" in the total colum (or zero if it's complicated),
and IF they put an "h" for Holiday it will put an 8 in that Total colum next
to.

I can't seem to get my head around how to do this.

Thank you,