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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove date format? 3
How do I delete merged cells in Excel without deleting the final d 5
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2
Can't graph data with Date Format with hours 2
Calculate the amount of time over a permitted amount (12 hours) 7
Changing date to eliminate day in format mm/dd/yyyy 1
Data to Date conversion with multiple formats 1
Problem sorting by date after 2029 on Excel 2003 1

Back
Top