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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

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,118,279
Messages
5,571,284
Members
412,375
Latest member
BRJoeyMelo
Top