I have some data from my friend.
- The first column is time, e.g.
01:02:59
- The second is a number, e.g.
5
I want to create a pivot table and then group the time to be sorted by hours (between 01:00:00
and 01:59:59
). I get an error "Cannot group that selection". I'm not sure why this happens.
Also, the time in the original cell is in an unknown format. It's aligned on the left side of the cell and if I double click on the cell, the time will jump to the right side. If I double click on all of them, all will finally be on the right side of cells – it works for grouping and then sorting by hours.
It looks like it is in some strange format – but I can not find in which one or what's wrong.