Subtotal of Sum of Hours and Not Count

[JFK_Lives]

Excel Version = 365
OS = Windows

Hi Everybody,

Still New to the whole Power Pivot thing so please bare with me as I will have a lot of Obvious Questions that might seem stupid.

Summary:

I have Engineers that work on Work Orders, Each Work Order has a Start Date, Start Time and a End Date and End Time, Multiple Engineers can work on one Work Order. All of this Information is Pulled into a Pivot Table and Grouped Per Engineer. Required is a Subtotal that Sum of All of the Hours worked by That Engineer on All Work Orders, At The Moment I can Only Get a Count Instead of a Sum.

Data Table:

This is how the Data Table looks like, with Formatting and Custom Column added to workout the Total Hours per Start and End Time.

Start Time Column
Data Type: Date
Format: hh:mm:ss (13:30:55)
Formula: None

End Time Column
Data Type: Date
Format: hh:mm:ss (13:30:55)
Formula: None

Hours (hh:mm:ss) Custom Column
Data Type: Date
Format: hh:mm:ss (13:30:55)
Formula: = End Time - Start Time

Pivot Table:

After Creating the Pivot Table, All the Columns look fine.
But as Soon as I move the Hours (hh:mm:ss) Field to the Values on the Right-hand Side, I either get a Count of or Nothing.
So for Asset Number MILT-PC701M which has Hours of 00:05:00/00:10:00/00:10:00/00:10:00/ which should be a Subtotal of 00:35:00 Minutes I get either 1 or 00:00:00

What am I missing here, is the Data Formatting Off, Need Another Custom Column or Formula?

Any Help or Suggestions will be Greatly Appreciated.

Thanks

 

[SullyWYO]

I suspect you have already tried this, but is it as simple as clicking on the "Count of Hours" (the area you have circled in red). and selecting "Sum" under the "Summarize value field by" setting?

If this isn't an option, it's possible that your hourly data is incorrectly formatted as text - you may want to check that as well.