• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

unknown format

M

Mike10

New Member
I have some data from my friend, first column is the time as ex. 01:02:59 and second is number ex. 5

once i will create pivot table and than want to group the time to be sorted by hours (between 01:00:00 and 01:59:59) will jump a error CANNOT GROUP THAT SELECTION. am not sure why ...

also the time in original cell is in unknown format, is on left side of cell and if i will double click on the cell the time will jump on right side of cell. If i will double click on all of them it and all of it will be finally on right side of cells it will works for grouping and than sorting by hours... it looks like is in some format but i can not find in which one or what's wrong...


any ideas ?
 
Hi Lukas. The cell format is already set to Time. but still the same...


Whatever cell format you will choose is still the same problem.
 
You must log in or register to reply here.
Back
Top