Sorting by time, not date

R

R

I have a column of date/time. ie the input in each row is something
like "3/14/05 1:30 PM" I need to sort this list by the time,
forgetting about the date. In other words, I don't care what date
something happened, but I want all the 9:00 am's at the top of the
list and all the 5:00 pm's at the bottom. (I tried changing the format
to just the time format, but that doesn't help!) How can I do this?

Thanks!
 
K

Ken Wright

Either get rid of all the dates, or make them all the same, or use a helper
column that does that and leave your real dates untouched.

Using a helper column, assuming your dates in A2:A200, in B2 put

=A2-INT(A2) and copy down

Now select all your data and sort on Col B
 

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

Amending meeting cancels all future meetings 0
Adding rota 0
Min, Max 3
Subtracting time...again 2
separating date and time 5
Averaging by half hour time intervals. 0
Problem formatting dates from CSV file 2
Extracting just the time portion 6

Top