Forum Discussion
Converting Actual Duration to Hours
- 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
As noted in the referenced post, no custom fields (e.g. Text, Duration, etc.) are timescaled so Text type won't work either.
John
If your goal is to convert the Duration field to hours
John
Thank you John-project,
the PM wants to define a Task with a Start, Finish and Duration, this means that the Resource assigned will have that timeframe to complete the task.
Then as in this environment resources are not fully dedicated to projects, the PM will enter the number of hours that the task actually will take so the Resource will have that timeframe (for instance 5 days) to complete a task that is done in 2h.
So Resource Hours are the number of hours that the Resource will actually use to complete the task within the provided duration.
For instance, in the Project Initiation Document production task there are 5 days to complete the task, the PM says the task is done in 5h (Resource Hours: 0.63d) and when updated to 50% complete, the Remaining Resource Hours are updated to 0.3125d, 2,5h keeping original duration, start and finish untouched.
On top of this, the user asked to keep track of all these Resource Hours and Remaining Resource Hours in the Project Online PBI Content Pack in dashboards like Resource Assignments, Resource Availability and so on. But I am guessing now that this is not going to be possible.
- 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- 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!- Ximo,
You're welcome and thanks for the feedback.