scheduled work exceeding available time

**cp49321** · 01-20-2013, 12:50 PM

Good day,
I have attached a portion of a schedule I have been asked to update to show when more hours
are scheduled for a time period than are available on the schedule.
Each Dept.(Man. and DCC) has 16 hours available per day, M-F.
How can I chart or show somehow when a conflict arises? I need to
outsource the excess time to another facility in a timely fashion.
I am open to any suggestions, the easier for management to review the better.
Thank you.
GKirbywork overload.xlsx

**Spencer101** · 01-20-2013, 01:06 PM

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.

**FDibbins** · 01-20-2013, 01:17 PM

Your profile shows 2003, but you uploaded a .xslx file, so i will assume you have 2007 or later (please update your profile)

If you mean that you want to be alerted is Manual Hrs+DCC Hrs exceed 16, then you can do this with conditional formatting...

1. highlight the range you want to apply the conditional formatting to
2. on the home tabe, styles, select CF
3. select new rule, select use formula
4. enter =($J2+$G2)>16

**cp49321** · 01-20-2013, 02:20 PM

Thank you for the suggestions, that helps me but I did not explain clearly what I need. Is there a way to take the total scheduled work hours, and show if there
are enough hours available on the schedule to complete it by the due date? I am not sure how to show this, any input is appreciated, or is there a better way to complete
a task like this?
Thank You!