Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date and time but date not wanted
Hi I have a column with dates and time in each cell. E.g. 13/08/07 9.31.13
the problem I have is, I want to sort the column in time order only not date and time. E.g 13/08/07 9.31.13 14/08/07 08.12.15 15/08/07 07.31.13 I want it to sort so that it ignores date and looks like this 7.31.13 8.12.15 9.31.13 Any help appreciated as I do not have a clue. If this is not clear please ask. Thanks Bill Edit/Delete Message |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
wanted to use if function by comparing date | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions |