| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert date/time to text
An automatically generated report has a column of dates/times in the format:
mm/dd/yyyy hh:mm:ss AM We want to be able to sort this column ONLY by the times. We don't care about the date. When we change the format of the cells to contain only the time, the sort sorts by the entire date/time (because we never really changed the contents of the cells). So, basically what I want to do is 'strip out' the date information, leaving only the time information. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
| How to convert columns of data to one column of text | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Threaded Mode
