scheduled work exceeding available time

Hi,

I'm not sure if I've understood your request perfectly, but attached is how I would deal with what I think you mean.

I've added a new 'table' that shows how many hours over 16 each day has scheduled. If the schedule for any day is 16 hours or under it shows nothings, if any day has over 16 hours scheduled it shows how many hours need outsourcing.

Is that of any use to you?

The table could just as easily be on another sheet for tidy purposes.