Forum Discussion
Converting Actual Duration to Hours
Hi all,
I have been able to convert [Duration] to hours with the formula:
ProjDurConv([Duration], pjhours)And I am displaying correctly the new column (Duration Hours):
I am trying to do the same with Actual Duration but unfortunately there must be something I am missing. Project Plan has been published, checked in, etc. The formula is the same but using the [Actual Duration]:
ProjDurConv([Actual Duration], pjhours)What am I missing?
Thanks!
- Ximo,
I don't understand what any of this has to do with timescaled data. The tasks should be set up as Fixed Duration type and estimated (not actual) effort entered into the Work field. I 'm not sure how the PM knows ahead of time what the actual work will be because until it actually happens, everything is an estimate.
I don't use Project Online nor do I use Power B1, so the statements in your last paragraph are beyond my scope. However, the fields you talk about (i.e. Duration, Work, Actual Work, Remaining Work, etc.) are all readily available for dashboard type reporting, no conversions necessary.
John
9 Replies
There is nothing wrong with your formula. This is what I get with Project 2019 Pro with:
Text2=ProjDurConv([Duration],pjHours)
Text3=ProjDurConv([Actual Duration],pjHours)
I suspect the issue has to do with check in and publishing, or it's possible your file has some corruption. You might try saving the file as XML and then re-open the XML in Project.
John
Thank you John-project, I see that you are using Task2 and Task3 fields as Text type, in my case the column Actual Duration Hours was type Duration because later on I was trying to use this field in the time phased datasets in the Project Online PBI Content Pack.
If I use the type Text it works but would a text type custom field work in the time phased datasets?
Thank you
- Ximo,
Results are the same? Does that mean it works when you use custom Text fields?
Keep in mind that the duration type in Project is in minutes (internally), regardless of how it may be displayed.
John
