pendulum
Board Regular
- Joined
- Feb 27, 2015
- Messages
- 53
- Office Version
- 2021
If I format my source table's time column as Time, then it looks nice, but then the pivot table will only show:
Though if I switch the format to General, then the pivot table displays the correct time format 10:21 PM, but the table's time is all decimalified.
What do?
It only shows the minutes.:00
:01
:02
...
:59
Though if I switch the format to General, then the pivot table displays the correct time format 10:21 PM, but the table's time is all decimalified.
What do?