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