Real task duration
in [Project]
|
Prev: How to prevent concurrent tasks (or make task time mutually exclus
Next: how to enter additional info to the existing name?
From: Rob Schneider on 13 May 2010 13:57 Danny_dH, Sorry ... I don't quite understand. Can you reframe the question? My hunch is that what you want/need to do should be able to be handled by Project without the need of all these special fields. What are you trying to do? In any event, to get the sums of custom field [Days Worked] in the summary rows, did you notice the control for that on the custom field dialogue box? --rms www.rmschneider.com On 13/05/10 15:46, Danny_dH wrote: > Hey Rob, > > this more or less does what it needs to.. > I know have the column Actual Work, which states x hours/task and x > hours/total job, I added a custom column (days worked), which weirdly enough > contains just [Actual Work] and displays the real amount of days worked (so > 8hours in the column Actual work displays 1 day in the days worked column. > Which is fine and as it should be.. > But then it show the sum (in this case, all the tasks add up to 51 hours in > the Actual work column) but it doesn't show the sum for the days worked > column.. it just states 0 days. > > Sorry if I'm being obsessive about this, but I want to get it > straightforward and easy to use :) > > > "Rob Schneider" wrote: > >> [Actual Work] will be stored in Project in Minutes. You could make a >> new Number custom field called [Actual Work Hours] and make it equal to >> the formula [Actual Work]/60 where the 60 converts minutes into hours. >> this work for your needs? >> >> --rms >> >> www.rmschneider.com >> >> >> >> >> On 12/05/10 14:26, Danny_dH wrote: >>> Hey both, >>> >>> just a general reply then: since the actual calculation I want is not >>> something project does by default: >>> >>> is it possible to have both actual work in hours and days? >>> >>> I know have set the following >>> >>> Day1: 8hours >>> Day2: - nothing >>> Day3: 8hours >>> >>> And the column Actual Work gives me 16 hours, which is fine, but I now want >>> an additional column that converts this hours> days.. >>> >>> possible? >>> >>> thanks a lot. >>> bR >>> Danny >>> >>> "JulieS" wrote: >>> >>>> You're welcome, Danny. You can enter work or duration in >>>> whatever time unit you want, ranging from minutes to months. >>>> Just include the unit measurement as you key enter data. >>>> >>>> Use: >>>> m for minutes >>>> h for hours >>>> d for days >>>> w for weeks >>>> mo for months >>>> >>>> Julie >>>> Project MVP >>>> >>>> Visit http://project.mvps.org/ for the FAQs and additional >>>> information about Microsoft Project >>>> >>>> On 5/7/2010 4:15 PM, Danny_dH wrote: >>>>> Hey Julie, >>>>> >>>>> well.. it is as you say: my idea of worked days/hours is different then what >>>>> project does with it.. >>>>> >>>>> My idea was that, when choosing the column 'actual duration', project should >>>>> calculate everything in days. >>>>> >>>>> I now changed the "Work is entered in" to days.. and now calculation is >>>>> fine in days.. but I cannot enter hours anymore.. >>>>> >>>>> maybe I want to much of it ;) >>>>> Is there a way to have both? >>>>> >>>>> Thanks for helping me out Julie :) >>>>> >>>>> >>>>> >>>>> "JulieS" wrote: >>>>> >>>>>> Thanks for the clarification, Danny. That helps. >>>>>> >>>>>> The summary (Main in your example) calculation is correct. If >>>>>> one of the subproject's total duration is 3 days, then the >>>>>> summary duration is 3 days. I don't understand how you expect it >>>>>> to show 2 workdays if it starts on Monday and ends at the end of >>>>>> the day on Wednesday. Is that not 3 days? >>>>>> >>>>>> I think the issue is in your interpretation of duration. It is >>>>>> *not* "man hours". If you'd like to see man hours, the correct >>>>>> field is Work. You may display work in days if that helps. See >>>>>> Tools> Options, Schedule tab -- "Work is entered in" setting. >>>>>> >>>>>> I hope this helps. Let us know how you get along. >>>>>> >>>>>> Julie >>>>>> Project MVP >>>>>> >>>>>> Visit http://project.mvps.org/ for the FAQs and additional >>>>>> information about Microsoft Project >>>>>> >>>>>> On 5/7/2010 3:52 AM, Danny_dH wrote: >>>>>>> Hello Julie, >>>>>>> >>>>>>> sorry bout the bad choice of date: I acutally ment 3 following days: >>>>>>> >>>>>>> better example: >>>>>>> Mon 4 jan> Wed 6 Jan >>>>>>> I am using the standard calendar, meaning, Mon-Fri, 8.00> 12.00, 13.00> >>>>>>> 17.00 >>>>>>> The rest of my situation stays the same.. so I hope this is more clear.. >>>>>>> >>>>>>> sorry bout the misunderstanding. >>>>>>> Danny >>>>>>> >>>>>>> "Danny_dH" wrote: >>>>>>> >>>>>>>> Hello, >>>>>>>> >>>>>>>> I'm a total Project Noob. I'm using Project 2007 and I want to do a >>>>>>>> 'simple'? task. >>>>>>>> >>>>>>>> I have a main project (MAIN). Then I have a sub project (indent 1)(SUB). >>>>>>>> This sub has 2 subprojects (indent 2) (SUB1 - SUB2). >>>>>>>> So it looks like this: >>>>>>>> MAIN start: 01/01 - end: 03/01 >>>>>>>> dur: 3 days >>>>>>>> SUB start: 01/01 - end: 03/01 >>>>>>>> dur: 3 days >>>>>>>> SUB1 start: 01/01 - end: 01/01 >>>>>>>> dur: 1day >>>>>>>> SUB2 start: 03/01 - end: 03/01 >>>>>>>> dur: 1day >>>>>>>> >>>>>>>> Now, that Projects says that the duration is 3 days.. ok.. I can live with >>>>>>>> that, but then I add a column named actual duration.. and that one does the >>>>>>>> same. >>>>>>>> When I now add a column 'Actual Work', it tells me SUB1: 8h, SUB2: 8h, SUB: >>>>>>>> 16h, MAIN: 16h.... so this column does a correct calculation. >>>>>>>> >>>>>>>> Now how can I add a column, which gives me the correct REAL sum of workdays, >>>>>>>> so one that says 2 days... I just want to have this overview to calculate my >>>>>>>> total number of spent workdays. >>>>>>>> >>>>>>>> Sorry if this is a stupidly simple question, but.. I don't seem to be able >>>>>>>> to find it. >>>>>>>> >>>>>>>> Any help should be appreciated. >>>>>> . >>>>>> >>>> . >>>> >> . >>
From: "Steve House" sjhouse at hotmail dot on 14 May 2010 04:30 Go to Tools Customize Fields where you created the Days Worked column and make sure it's set to rollup to summaries -- Steve House MS Project Trainer & Consultant "Danny_dH" <DannydH(a)discussions.microsoft.com> wrote in message news:0E793FD7-3BE4-4B8C-8CC0-7B7DE8139638(a)microsoft.com... > Hey Rob, > > this more or less does what it needs to.. > I know have the column Actual Work, which states x hours/task and x > hours/total job, I added a custom column (days worked), which weirdly > enough > contains just [Actual Work] and displays the real amount of days worked > (so > 8hours in the column Actual work displays 1 day in the days worked column. > Which is fine and as it should be.. > But then it show the sum (in this case, all the tasks add up to 51 hours > in > the Actual work column) but it doesn't show the sum for the days worked > column.. it just states 0 days. > > Sorry if I'm being obsessive about this, but I want to get it > straightforward and easy to use :) > > > "Rob Schneider" wrote: > >> [Actual Work] will be stored in Project in Minutes. You could make a >> new Number custom field called [Actual Work Hours] and make it equal to >> the formula [Actual Work]/60 where the 60 converts minutes into hours. >> this work for your needs? >> >> --rms >> >> www.rmschneider.com >> >> >> >> >> On 12/05/10 14:26, Danny_dH wrote: >> > Hey both, >> > >> > just a general reply then: since the actual calculation I want is not >> > something project does by default: >> > >> > is it possible to have both actual work in hours and days? >> > >> > I know have set the following >> > >> > Day1: 8hours >> > Day2: - nothing >> > Day3: 8hours >> > >> > And the column Actual Work gives me 16 hours, which is fine, but I now >> > want >> > an additional column that converts this hours> days.. >> > >> > possible? >> > >> > thanks a lot. >> > bR >> > Danny >> > >> > "JulieS" wrote: >> > >> >> You're welcome, Danny. You can enter work or duration in >> >> whatever time unit you want, ranging from minutes to months. >> >> Just include the unit measurement as you key enter data. >> >> >> >> Use: >> >> m for minutes >> >> h for hours >> >> d for days >> >> w for weeks >> >> mo for months >> >> >> >> Julie >> >> Project MVP >> >> >> >> Visit http://project.mvps.org/ for the FAQs and additional >> >> information about Microsoft Project >> >> >> >> On 5/7/2010 4:15 PM, Danny_dH wrote: >> >>> Hey Julie, >> >>> >> >>> well.. it is as you say: my idea of worked days/hours is different >> >>> then what >> >>> project does with it.. >> >>> >> >>> My idea was that, when choosing the column 'actual duration', project >> >>> should >> >>> calculate everything in days. >> >>> >> >>> I now changed the "Work is entered in" to days.. and now calculation >> >>> is >> >>> fine in days.. but I cannot enter hours anymore.. >> >>> >> >>> maybe I want to much of it ;) >> >>> Is there a way to have both? >> >>> >> >>> Thanks for helping me out Julie :) >> >>> >> >>> >> >>> >> >>> "JulieS" wrote: >> >>> >> >>>> Thanks for the clarification, Danny. That helps. >> >>>> >> >>>> The summary (Main in your example) calculation is correct. If >> >>>> one of the subproject's total duration is 3 days, then the >> >>>> summary duration is 3 days. I don't understand how you expect it >> >>>> to show 2 workdays if it starts on Monday and ends at the end of >> >>>> the day on Wednesday. Is that not 3 days? >> >>>> >> >>>> I think the issue is in your interpretation of duration. It is >> >>>> *not* "man hours". If you'd like to see man hours, the correct >> >>>> field is Work. You may display work in days if that helps. See >> >>>> Tools> Options, Schedule tab -- "Work is entered in" setting. >> >>>> >> >>>> I hope this helps. Let us know how you get along. >> >>>> >> >>>> Julie >> >>>> Project MVP >> >>>> >> >>>> Visit http://project.mvps.org/ for the FAQs and additional >> >>>> information about Microsoft Project >> >>>> >> >>>> On 5/7/2010 3:52 AM, Danny_dH wrote: >> >>>>> Hello Julie, >> >>>>> >> >>>>> sorry bout the bad choice of date: I acutally ment 3 following >> >>>>> days: >> >>>>> >> >>>>> better example: >> >>>>> Mon 4 jan> Wed 6 Jan >> >>>>> I am using the standard calendar, meaning, Mon-Fri, 8.00> 12.00, >> >>>>> 13.00> >> >>>>> 17.00 >> >>>>> The rest of my situation stays the same.. so I hope this is more >> >>>>> clear.. >> >>>>> >> >>>>> sorry bout the misunderstanding. >> >>>>> Danny >> >>>>> >> >>>>> "Danny_dH" wrote: >> >>>>> >> >>>>>> Hello, >> >>>>>> >> >>>>>> I'm a total Project Noob. I'm using Project 2007 and I want to do >> >>>>>> a >> >>>>>> 'simple'? task. >> >>>>>> >> >>>>>> I have a main project (MAIN). Then I have a sub project (indent >> >>>>>> 1)(SUB). >> >>>>>> This sub has 2 subprojects (indent 2) (SUB1 - SUB2). >> >>>>>> So it looks like this: >> >>>>>> MAIN start: 01/01 - end: 03/01 >> >>>>>> dur: 3 days >> >>>>>> SUB start: 01/01 - end: >> >>>>>> 03/01 >> >>>>>> dur: 3 days >> >>>>>> SUB1 start: 01/01 - end: >> >>>>>> 01/01 >> >>>>>> dur: 1day >> >>>>>> SUB2 start: 03/01 - end: >> >>>>>> 03/01 >> >>>>>> dur: 1day >> >>>>>> >> >>>>>> Now, that Projects says that the duration is 3 days.. ok.. I can >> >>>>>> live with >> >>>>>> that, but then I add a column named actual duration.. and that one >> >>>>>> does the >> >>>>>> same. >> >>>>>> When I now add a column 'Actual Work', it tells me SUB1: 8h, SUB2: >> >>>>>> 8h, SUB: >> >>>>>> 16h, MAIN: 16h.... so this column does a correct calculation. >> >>>>>> >> >>>>>> Now how can I add a column, which gives me the correct REAL sum of >> >>>>>> workdays, >> >>>>>> so one that says 2 days... I just want to have this overview to >> >>>>>> calculate my >> >>>>>> total number of spent workdays. >> >>>>>> >> >>>>>> Sorry if this is a stupidly simple question, but.. I don't seem to >> >>>>>> be able >> >>>>>> to find it. >> >>>>>> >> >>>>>> Any help should be appreciated. >> >>>> . >> >>>> >> >> . >> >> >> . >>
From: Danny_dH on 14 May 2010 17:56
WOOHOOO that's IT!!!! Finally got my total days worked sum :) GREAT GREAT.. Thanks everyone for contributing!!! "Steve House" wrote: > Go to Tools Customize Fields where you created the Days Worked column and > make sure it's set to rollup to summaries > -- > Steve House > MS Project Trainer & Consultant > > "Danny_dH" <DannydH(a)discussions.microsoft.com> wrote in message > news:0E793FD7-3BE4-4B8C-8CC0-7B7DE8139638(a)microsoft.com... > > Hey Rob, > > > > this more or less does what it needs to.. > > I know have the column Actual Work, which states x hours/task and x > > hours/total job, I added a custom column (days worked), which weirdly > > enough > > contains just [Actual Work] and displays the real amount of days worked > > (so > > 8hours in the column Actual work displays 1 day in the days worked column. > > Which is fine and as it should be.. > > But then it show the sum (in this case, all the tasks add up to 51 hours > > in > > the Actual work column) but it doesn't show the sum for the days worked > > column.. it just states 0 days. > > > > Sorry if I'm being obsessive about this, but I want to get it > > straightforward and easy to use :) > > > > > > "Rob Schneider" wrote: > > > >> [Actual Work] will be stored in Project in Minutes. You could make a > >> new Number custom field called [Actual Work Hours] and make it equal to > >> the formula [Actual Work]/60 where the 60 converts minutes into hours. > >> this work for your needs? > >> > >> --rms > >> > >> www.rmschneider.com > >> > >> > >> > >> > >> On 12/05/10 14:26, Danny_dH wrote: > >> > Hey both, > >> > > >> > just a general reply then: since the actual calculation I want is not > >> > something project does by default: > >> > > >> > is it possible to have both actual work in hours and days? > >> > > >> > I know have set the following > >> > > >> > Day1: 8hours > >> > Day2: - nothing > >> > Day3: 8hours > >> > > >> > And the column Actual Work gives me 16 hours, which is fine, but I now > >> > want > >> > an additional column that converts this hours> days.. > >> > > >> > possible? > >> > > >> > thanks a lot. > >> > bR > >> > Danny > >> > > >> > "JulieS" wrote: > >> > > >> >> You're welcome, Danny. You can enter work or duration in > >> >> whatever time unit you want, ranging from minutes to months. > >> >> Just include the unit measurement as you key enter data. > >> >> > >> >> Use: > >> >> m for minutes > >> >> h for hours > >> >> d for days > >> >> w for weeks > >> >> mo for months > >> >> > >> >> Julie > >> >> Project MVP > >> >> > >> >> Visit http://project.mvps.org/ for the FAQs and additional > >> >> information about Microsoft Project > >> >> > >> >> On 5/7/2010 4:15 PM, Danny_dH wrote: > >> >>> Hey Julie, > >> >>> > >> >>> well.. it is as you say: my idea of worked days/hours is different > >> >>> then what > >> >>> project does with it.. > >> >>> > >> >>> My idea was that, when choosing the column 'actual duration', project > >> >>> should > >> >>> calculate everything in days. > >> >>> > >> >>> I now changed the "Work is entered in" to days.. and now calculation > >> >>> is > >> >>> fine in days.. but I cannot enter hours anymore.. > >> >>> > >> >>> maybe I want to much of it ;) > >> >>> Is there a way to have both? > >> >>> > >> >>> Thanks for helping me out Julie :) > >> >>> > >> >>> > >> >>> > >> >>> "JulieS" wrote: > >> >>> > >> >>>> Thanks for the clarification, Danny. That helps. > >> >>>> > >> >>>> The summary (Main in your example) calculation is correct. If > >> >>>> one of the subproject's total duration is 3 days, then the > >> >>>> summary duration is 3 days. I don't understand how you expect it > >> >>>> to show 2 workdays if it starts on Monday and ends at the end of > >> >>>> the day on Wednesday. Is that not 3 days? > >> >>>> > >> >>>> I think the issue is in your interpretation of duration. It is > >> >>>> *not* "man hours". If you'd like to see man hours, the correct > >> >>>> field is Work. You may display work in days if that helps. See > >> >>>> Tools> Options, Schedule tab -- "Work is entered in" setting. > >> >>>> > >> >>>> I hope this helps. Let us know how you get along. > >> >>>> > >> >>>> Julie > >> >>>> Project MVP > >> >>>> > >> >>>> Visit http://project.mvps.org/ for the FAQs and additional > >> >>>> information about Microsoft Project > >> >>>> > >> >>>> On 5/7/2010 3:52 AM, Danny_dH wrote: > >> >>>>> Hello Julie, > >> >>>>> > >> >>>>> sorry bout the bad choice of date: I acutally ment 3 following > >> >>>>> days: > >> >>>>> > >> >>>>> better example: > >> >>>>> Mon 4 jan> Wed 6 Jan > >> >>>>> I am using the standard calendar, meaning, Mon-Fri, 8.00> 12.00, > >> >>>>> 13.00> > >> >>>>> 17.00 > >> >>>>> The rest of my situation stays the same.. so I hope this is more > >> >>>>> clear.. > >> >>>>> > >> >>>>> sorry bout the misunderstanding. > >> >>>>> Danny > >> >>>>> > >> >>>>> "Danny_dH" wrote: > >> >>>>> > >> >>>>>> Hello, > >> >>>>>> > >> >>>>>> I'm a total Project Noob. I'm using Project 2007 and I want to do > >> >>>>>> a > >> >>>>>> 'simple'? task. > >> >>>>>> > >> >>>>>> I have a main project (MAIN). Then I have a sub project (indent > >> >>>>>> 1)(SUB). > >> >>>>>> This sub has 2 subprojects (indent 2) (SUB1 - SUB2). > >> >>>>>> So it looks like this: > >> >>>>>> MAIN start: 01/01 - end: 03/01 > >> >>>>>> dur: 3 days > >> >>>>>> SUB start: 01/01 - end: > >> >>>>>> 03/01 > >> >>>>>> dur: 3 days > >> >>>>>> SUB1 start: 01/01 - end: > >> >>>>>> 01/01 > >> >>>>>> dur: 1day > >> >>>>>> SUB2 start: 03/01 - end: > >> >>>>>> 03/01 > >> >>>>>> dur: 1day > >> >>>>>> > >> >>>>>> Now, that Projects says that the duration is 3 days.. ok.. I can > >> >>>>>> live with > >> >>>>>> that, but then I add a column named actual duration.. and that one > >> >>>>>> does the > >> >>>>>> same. > >> >>>>>> When I now add a column 'Actual Work', it tells me SUB1: 8h, SUB2: > >> >>>>>> 8h, SUB: > >> >>>>>> 16h, MAIN: 16h.... so this column does a correct calculation. > >> >>>>>> > >> >>>>>> Now how can I add a column, which gives me the correct REAL sum of > >> >>>>>> workdays, > >> >>>>>> so one that says 2 days... I just want to have this overview to > >> >>>>>> calculate my > >> >>>>>> total number of spent workdays. > >> >>>>>> > >> >>>>>> Sorry if this is a stupidly simple question, but.. I don't seem to > >> >>>>>> be able > >> >>>>>> to find it. > >> >>>>>> > >> >>>>>> Any help should be appreciated. > >> >>>> . > >> >>>> > >> >> . > >> >> > >> . > >> > > . > |