Daily scheudule help
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,
|