How do i get the pivot table to use re-formatted data?

New Contributor

I reformatted the time to use military time in column



When inserting a pivot table, it still uses the original format of time:



How do i get the pivot table to recognize the 24 hour time?

3 Replies
Its necessary you format the pivot table format as well. You just right click over fields and select Value Field Setting >> Format Number ...

@Juliano-Petrukio Hi, i did that and im not sure which one to select? 


thanks for your help



You cannot.  You'll have to get creative