Thank you, but that won't work. I have days where the supervisor may be out, but the employee is in. The variable can't be zero in this case, because there are 8 hours in that day when the employee does not have a supervisor present (there is no overlap that day). Hope that makes sense.