Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-02-2023, 07:17 AM
ICNARC261 ICNARC261 is offline Actual number of days working on the task VS period of time to complete the task Windows 11 Actual number of days working on the task VS period of time to complete the task Office 2021
Novice
Actual number of days working on the task VS period of time to complete the task
 
Join Date: May 2023
Posts: 1
ICNARC261 is on a distinguished road
Question Actual number of days working on the task VS period of time to complete the task

Hi All,

You may find my question stupid, but after a long hassle, I decided to ask for help.

Given: Say I input a new summary task for the project and say this summary task has 5 tasks. The time period for each task is 1 week (5 days) and the time gap between tasks is 3 weeks (15 days). I set the project time to be calculated in days. After all that, my summary task shows that the total amount of working time is 100 days (working + gap), instead of 25 days of actual work.

Pop-quiz: how can I set the summary task to show the actual amount of working time instead of the total time including gaps?

Sorry if it all sounds confusing, I tried to be as specific as I could.


Thanks to everyone in advance!

P.S. I use MP 365
Reply With Quote
  #2  
Old 05-02-2023, 08:55 AM
DaleHowardMVP DaleHowardMVP is offline Actual number of days working on the task VS period of time to complete the task Windows 10 Actual number of days working on the task VS period of time to complete the task Office 2021
Advanced Beginner
 
Join Date: Apr 2023
Posts: 46
DaleHowardMVP is on a distinguished road
Default

I already answered your question in the Project user forum at:

Actual number of days working on the task VS period of time to complete the task - Microsoft Community Hub
Reply With Quote
  #3  
Old 05-02-2023, 10:04 AM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Actual number of days working on the task VS period of time to complete the task Windows 10 Actual number of days working on the task VS period of time to complete the task Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 72
ProjectPlanner is on a distinguished road
Default

Use a custom Duration field (say Duration1) with formula = [Duration] and under the calculation for task and group summary rows, tick the Rollup checkbox and select Sum from the dropdown.

Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Any way to display the portion of a task that is split by non-working time in a different colour? jraward Project 1 04-21-2023 08:06 PM
Competing a task in Outlook does not automtically complete the linked task in OneNote OneGoat OneNote 0 06-22-2017 05:55 AM
Actual number of days working on the task VS period of time to complete the task Creating a task similar to Working Time exceptions jaywizz1 Project 1 11-04-2016 10:30 AM
Allocation of task in certain period of time mati2 Project 1 02-25-2012 07:59 AM
how to make the task starts next day if no time enough today(task can not be split) duraid Project 1 10-25-2010 08:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:42 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