Assistance with Time Format in Pivot Table

jsheets

New Member
Joined
Oct 28, 2020
Messages
8
Office Version
  1. 365
Platform
  1. Windows
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.

1605289455977.png
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

6StringJazzer

Well-known Member
Joined
Jan 27, 2010
Messages
700
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Oct 28, 2020
Messages
8
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,088
Messages
5,576,040
Members
412,694
Latest member
Deaf1Too
Top