Hi,
I have an excel column with date/time as
time(as hour)
2011-08-19 00:00:00
2011-08-19 01:00:00
2011-08-19 02:00:00
2011-08-20 00:00:00
2011-08-20 01:00:00
2011-08-20 02:00:00
can this be sorted based on time without separating the time into a separate column?
so the result is
2011-08-19 00:00:00
2011-08-20 00:00:00
2011-08-19 01:00:00
2011-08-20 01:00:00
2011-08-19 02:00:00
2011-08-20 02:00:00
Thanks for any help!
bha
Try this...?
TimeSorting.PNG
=N(CELL) converts your DateTime into a value
=MOD(N(CELL),1) will remove the whole-number portion of the DateTime, leaving you with the Time Portion
After that, sort using filter (Alt+ D+F+F)
So in conclusion...
1.) If your DateTime is in A2, key this into B2: =MOD(N(A2),1)
2.) Sort using Filter
I think some of the other may be able to, but I won't be able to sort it without an additional column.
Well, hope this helps to a certain degree!
Last edited by SCLai; 05-04-2012 at 04:51 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks