Assistance with Time Format in Pivot Table

[jsheets]

Good Day everyone! Looking for a little assistance. I have a the time in L2 that shows as 00:01:00 (using format: Time>37:30:55) but when I reference this data set to create a pivot table it shows up as 12:01:00 AM. I need it to read as 00:01:00. Any assistance would be most appreciated.

 

[6StringJazzer]

I'm confused about what you see as a problem. In your screenshot the value appears to be displayed as 0:01:00 in the pivot table. The formula box shows that the underlying data value is 12:01:00 AM, which is what it is in your source data, and which isn't going to change no matter how you display it.

 

[jsheets]

I'm confused about what you see as a problem. In your screenshot the value appears to be displayed as 0:01:00 in the pivot table. The formula box shows that the underlying data value is 12:01:00 AM, which is what it is in your source data, and which isn't going to change no matter how you display it.

no the data in the pivot table is showing as 12:01:00 when using it in the filter category, I want it to read 00:01:00 like the raw data shows.