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

%3CLINGO-SUB%20id%3D%22lingo-sub-2754006%22%20slang%3D%22en-US%22%3EHow%20do%20i%20get%20the%20pivot%20table%20to%20use%20re-formatted%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2754006%22%20slang%3D%22en-US%22%3E%3CP%3EI%20reformatted%20the%20time%20to%20use%20military%20time%20in%20column%20%3CLI-EMOJI%20id%3D%22lia_anguished-face%22%20title%3D%22%3Aanguished_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22juniebug_0-1631731396248.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310639iE938EB042B2C72CD%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22juniebug_0-1631731396248.png%22%20alt%3D%22juniebug_0-1631731396248.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20inserting%20a%20pivot%20table%2C%20it%20still%20uses%20the%20original%20format%20of%20time%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22juniebug_1-1631731444914.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310640i6F6ECBBD8985F719%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22juniebug_1-1631731444914.png%22%20alt%3D%22juniebug_1-1631731444914.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20i%20get%20the%20pivot%20table%20to%20recognize%20the%2024%20hour%20time%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2754006%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2754025%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20i%20get%20the%20pivot%20table%20to%20use%20re-formatted%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2754025%22%20slang%3D%22en-US%22%3EIts%20necessary%20you%20format%20the%20pivot%20table%20format%20as%20well.%20You%20just%20right%20click%20over%20fields%20and%20select%20Value%20Field%20Setting%20%26gt%3B%26gt%3B%20Format%20Number%20...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2754055%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20i%20get%20the%20pivot%20table%20to%20use%20re-formatted%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2754055%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767933%22%20target%3D%22_blank%22%3E%40Juliano-Petrukio%3C%2FA%3E%26nbsp%3BHi%2C%20i%20did%20that%20and%20im%20not%20sure%20which%20one%20to%20select%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22juniebug_0-1631732281117.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310645iC043808AA298E603%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22juniebug_0-1631732281117.png%22%20alt%3D%22juniebug_0-1631732281117.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ethanks%20for%20your%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I reformatted the time to use military time in column

juniebug_0-1631731396248.png

 

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

juniebug_1-1631731444914.png

 

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? 

juniebug_0-1631732281117.png

thanks for your help

@juniebug 

 

You cannot.  You'll have to get creative