Daily scheudule help

W

Wyl

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,
 
T

Toppers

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?
 
Top