Cell Formating/Sorting

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a worksheet which has 2 columns. Fist column
contains time/date data in the format dd/mm/yy hh:mm. The
second column contains data relating to the first column.
The data is sorted by date. I wish to sort the data by
time. I have tried to copy the first column into a new
column, changed the format of the cells to date for the
one and time for the second. Although the data in the
cell appears to show either date or time, clicking on a
cell still shows the data in the original format, so it
won't sort by time. Any help appreciated.

Regards
Mike
 
Mike

Dates are whole numbers and time is expressed as decimal
fractions of a day. Use a Helper column to find the time
with this formula
=A4-INT(A4)
Sort on the this column.

Regards
Peter
 
Back
Top