Way to show the different Hour Types that were logged on a task within a calculated field within that task?

[Dusty_H]

I'm looking for a way to show within a form attached to a task the different Hour Types that were logged to it. 
For instance we use Task time and Support Time.  when i pull a Task report i want to know if only Task time, only Support time or if both Task and Support time were logged on that specific Job.

Is there a way to do this within a calculated form field?

Trying to avoid having to pull an Hours report as that will result in much more data manipulation when exported to do analysis.

additionally.. not sure if there is a way to use calculated fields to total the different Hour types within the task 
show a total of all Support time logged, and total of all Task time logged.

thanks!!

[Madalyn_Destafney]

Hi there, I was going to direct you to an hour report with filter for hour type, but since you don't want to go that route have you considered just using the Hours tab on the task to see the hour breakdown? You could apply an Hour view so you could include info you want like Hour Type/entry date/and sort, filter, etc (if the default Hours tab view isn't what you're after). I'm not sure about the calculated field side of this.

[Dusty_H]

looking at each individual task and the hour tab within that task is not something we could support.  We process hundreds of tasks each day and want to be able to pull a Job report that we can export and understand the types of hours logged per individual task.  
i know i can bring total hours logged into a calculated field but want to be able to also show the different hour types that were logged within that individual task.

[MorganHatcher]

I had a similar issue and the only solve was for Fusion to pull the hours associated with a certain hour type and populate to a task field. 

[skyehansen]

sorry to have to ask: what’s a “job”? Is it a project or a task or something else?

[Dusty_H]

Sorry for the confusion! When I say "job," I actually mean "task." We use the term "job" internally to refer to tasks, and I was trying to avoid using it to prevent confusion. I slipped out of habit. Hope that clears it up!

[skyehansen]

I feel like from what you have been saying, you could get away with using an hours report. Have you considered the matrix view? I'm including a sample that is grouped by hour type on the column groupings and task name on the row groupings, but this would not work if all your tasks have the same name of course. You would probably have to group by guid.