Hello everyone,
I am trying to sort a column so it'd be like a schedule the earliest time on top and latest on the bottom. I understand it is a form of custom listing but I am not quite sure what is the way to enter that list entry...attached is my excel spreadsheet I am currently working on.
Thanks in advance.schedule.xlsx
Why can not you use the sort function?
My sort function doesn't seem to offer earliest time on top :S. It seems to have to be a formula or a custom entree.
Those values in the second column are not times (numbers between 0.0 and 0.999...), they are string values
Ben Van Johnson
Ah I see my bad, well is there a way to sort string values then ? :O
The "time" column is not usable without a lot of surgery. You should redo it putting start and end times in separate columns.
Heh, came to that conclusion after a lot of head banging. Should've been obvious. Thanks for the reply none the less.
Add another help column to sort.
C2
drag down. Use sort feature in column C.
=TIMEVALUE(IFERROR(LEFT(B2,FIND("-",B2)-1) &" "& RIGHT(B2,2),LEFT(B2,LEN(B2)-2) & " "&RIGHT(B2,2)))
See attached.
HTH,
WindKnife
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
hanzechin 
Register To Reply
Bookmarks