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,