excel breaking up time

New Contributor

i only have one time column in my data, but when I add it to the rows area in my pivot table excel break it up into two sometimes three time entries something like this Hours (Time) Minutes (Time) and Sec onds (Time.


I only have one set for timeand I want it to display exactly the way i add it not with the hour with a plus to open the minutes, this looks terrable .




the time should be 1:33 PM all on one line.

3 Replies


Right click on Hours and from menu select Ungroup



@Sergei Baklanthank you so much for an easy solution to a problem that was driving me crazy.



@jayd1520 , you are welcome, glad to help


Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies