Forum Discussion
Solved
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...
- 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
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
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
Timescaled is related because the user wanted to know all the assignments Resource Hours and Remaining Resource Hours planned for next week, or next month or check how the last month or week went, have a heat map with overallocations (more than 8 hours per day per resource, etc.)
Fixed duration would actually make the trick! Thanks a lot!
Fixed duration would actually make the trick! Thanks a lot!
- Ximo,
You're welcome and thanks for the feedback.