SOLVED
Home

excel breaking up time

%3CLINGO-SUB%20id%3D%22lingo-sub-788311%22%20slang%3D%22en-US%22%3Eexcel%20breaking%20up%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788311%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20only%20have%20one%20time%20column%20in%20my%20data%2C%20but%20when%20I%20add%20it%20to%20the%20rows%20area%20in%20my%20pivot%20table%20excel%20break%20it%20up%20into%20two%20sometimes%20three%20time%20entries%20something%20like%20this%20Hours%20(Time)%20Minutes%20(Time)%20and%20Sec%20onds%20(Time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20only%20have%20one%20set%20for%20timeand%20I%20want%20it%20to%20display%20exactly%20the%20way%20i%20add%20it%20not%20with%20the%20hour%20with%20a%20plus%20to%20open%20the%20minutes%2C%20this%20looks%20terrable%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125621i2EBAFEC5EBC997EB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20time%20should%20be%201%3A33%20PM%20all%20on%20one%20line.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-788311%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-788923%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20breaking%20up%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788923%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387480%22%20target%3D%22_blank%22%3E%40jayd1520%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERight%20click%20on%20Hours%20and%20from%20menu%20select%20Ungroup%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125652i45A05C2218A5FA07%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-788984%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20breaking%20up%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788984%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3Ethank%20you%20so%20much%20for%20an%20easy%20solution%20to%20a%20problem%20that%20was%20driving%20me%20crazy.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E2%98%BA%E2%98%BA%E2%98%BA%E2%98%BA%E2%98%BA%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-788989%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20breaking%20up%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788989%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387480%22%20target%3D%22_blank%22%3E%40jayd1520%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%2C%20glad%20to%20help%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
jayd1520
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 .

 

clipboard_image_0.png

 

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

3 Replies
Solution

@jayd1520 

Right click on Hours and from menu select Ungroup

clipboard_image_0.png

 

@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