Forum Discussion
PivotTable regression in Version 2609. Duration fields formatted [h]:mm:ss no longer allow Sum.
Excel 365 Version 2609 (Build 16.0.20430.20032) appears to have changed PivotTable handling of duration fields formatted as mm:ss. New PivotTables default to Count of Total Hours and Value Field Sett...
Hello,
I’m seeing the same behavior on my 64-bit beta version (2611 Build 16.0.20601.20000)!
Workarounds found:
1- For the first PivotTable, first change the data format to "General," create the table while checking the "Add to Data Model" box, then switch the format back to "Time."
Subsequent PivotTables should then work.
2- Use Power Pivot.