PC Review


Reply
Thread Tools Rate Thread

Charting with Work Days

 
 
New Member
Join Date: Aug 2005
Posts: 1
 
      22nd Aug 2005
Hello,

I have created a stacked bar chart to depict the amount of time it takes each of my technicians to complete a project. The issue I am running into is when I assign my technicians a task that takes several days or even weeks. If I am planning on assigning this task to someone and assuming it should take them 40 hours to complete it, I don't want that 40 hours to be completed in the first two days. I want the chart to recognize an 8 hour working day as well as weekends. The only time I would like the chart to recognize the weekends or hours not between 8AM-5PM, would be for overtime. Does anyone know how to accomplish this? Is there a way to assign each day a value of 8 hours or something? Any help would be appreciated.

Thank you in advance for any assistance.

-eforti
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Business Days / Work Days only / Date Math dl Microsoft Access Queries 0 12th Feb 2009 07:18 PM
Access query work days function over 20 days =?Utf-8?B?ZGJ3b25nODg=?= Microsoft Access Getting Started 3 17th Oct 2007 06:28 PM
pivot charting doesn't work for me - bill - =?Utf-8?B?YmlsbHlfYmFncw==?= Microsoft Excel Charting 1 14th Jun 2007 04:29 PM
How to set up 3 days at work 3 days off work repeating? =?Utf-8?B?R2xlbm4gVHJpY2FyaWNv?= Microsoft Outlook Calendar 2 12th Feb 2007 11:57 PM
labo work charting Zekni Microsoft Excel Charting 5 5th Mar 2006 06:03 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:02 AM.