Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-03-2014, 08:47 PM
bumpui bumpui is offline How do I calculate planned work for a given time period Windows 7 64bit How do I calculate planned work for a given time period Office 2010 64bit
Novice
How do I calculate planned work for a given time period
 
Join Date: Jun 2014
Posts: 6
bumpui is on a distinguished road
Default How do I calculate planned work for a given time period

Hi all,
I use MS Project Standard
I have several tasks and resources allocated and we have planned start and finish dates for the tasks.


I wanted to know how many person days are planned for a given time period for a given summary task (which may include 100s of tasks).
The summary task showed me the overall planned days for the entire time frame. I set a filter, starting date 1.7.2014 or later, end date 31.10.2014 or earlier and got the tasks which match this criteria. But the summary tasks working days did not change, so it still shoed the entire amount of effort in the summary task. How can I get the amount of planned working days just for the filtered tasks?
Thanks in advance
Bumpui
Reply With Quote
  #2  
Old 06-04-2014, 06:37 AM
JulieS JulieS is offline How do I calculate planned work for a given time period Windows 7 64bit How do I calculate planned work for a given time period Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Sorry, but filtering does not restrict values. Take a look at the visual reports and you can see the break down per time period (month, week) etc. per task. For example, you may change the Cash Flow Visual Report to show Work instead of money and filter the report by tasks.
Reply With Quote
Reply

Tags
effort calculation, filter, time frame



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to calculate Date and Time funkyfido Excel 2 06-25-2013 04:25 PM
Allocation of task in certain period of time mati2 Project 1 02-25-2012 07:59 AM
Can't change period when adjusting actual time in Web Access chip_saffire Project 0 10-04-2011 12:05 AM
How do I calculate planned work for a given time period Add a period of time to a referenced "Time" cell? derelyth Excel 4 03-27-2011 04:31 PM
How do I calculate planned work for a given time period How to get cells to calculate time? jrasche2003@yahoo.com Excel 2 02-09-2007 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft