Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

Has anyone else noticed that the total hours on the hours page of a project is either needs to be worded different or fixed?

Avatar

Level 7

Has anyone noticed that when you go to the Hours page of Project, the total at the bottom says, 'Total Hours x". However, it isn't actually total hours. It is calculating total number of entries. So, the wording is misleading and I'm not sure of the value of knowing how many entries were done vs. the total hours. If you look at my example. You will see the "Total Hours' say three. There are three entries, but the total hours are actually 4.25. Am I not seeing this correctly?hours example.png 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

How about create a grouping by Owner, and a view that aggregates the Hour column? This way you can get your hours grouped by owner and a total all in one view.

Like this:

Screenshot 2023-02-08 at 12.42.44 pm.jpg

 

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.

View solution in original post

5 Replies

Avatar

Community Advisor

Yes, it's certainly confusing. I always set the Grouping on my hours page to Project, that will group all hours for that project together (not that it would be pulling in hours for any other project when you're in a single project ). But this does total the Hours column at the top of that column.

Avatar

Community Advisor

I agree with you.

But from technical perspective, I understand it.

In a task list it says "Showing 3 tasks", in a project list it says "Showing 3 projects" so it makes sense that in an hours list it says "Showing 3 hours" as it's seeing hours entries, not the sum. Just like with projects and tasks.

Avatar

Community Advisor

We had a report intended to track hours using that field at the bottom and I quickly did the math and realized it was counting the entries and not the time

 

We brought this up with our Workfront rep on a monthly cadence call and they were unaware, until then, that it was being calculated this way

Avatar

Correct answer by
Community Advisor

How about create a grouping by Owner, and a view that aggregates the Hour column? This way you can get your hours grouped by owner and a total all in one view.

Like this:

Screenshot 2023-02-08 at 12.42.44 pm.jpg

 

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.

Avatar

Community Advisor

We do this but also clicking the Summary button allows us to view the numerical values instead of log entries if we don't have a particular report grouped in that way