Pivot table averages are wrong

[Holytuna]

So I have a pivot table and this pivot table is set to averages and the format of mm:ss the same is set in the column that has the data in the table.

I could even have one row of 23:01 And it will still show something like 57:42 I do have some blank values that would be returned set as 00:00

It does not throw out and div or ref errors which is good. I even had it remove blank values and still get the same results!

Any thoughts or suggestions?

 

[RoryA]

Welcome to the forum.

I'd pretty much guarantee it's a data issue. Perhaps your source data is formatted in such a way that it doesn't display its real values - eg it's formatted as hh:mm but contains a date portion too.

 

[Holytuna]

Welcome to the forum.

I'd pretty much guarantee it's a data issue. Perhaps your source data is formatted in such a way that it doesn't display its real values - eg it's formatted as hh:mm but contains a date portion too.

You are absolutely correct that turned out to be the issue. I did a power query removed it and worked as needed. Thank you so much for your input