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
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