Prev: Permutations with conflicting groups
Next: Counting strings of consecutive numbers in a column
From: adammled on 27 Jan 2010 00:13
I have a single column of data that includes dates in two formats:
mddyy
mddyy hh:mm

I tried using the Data>Text-to-Columns... with mdy to change them to dates.
It worked for the mddyy data, but it messed up the mddyy hh:mm data.

I need to convert these so I can sort them by year>month>day>hour>minute.
From: Jacob Skaria on 27 Jan 2010 00:19
If all the dates are in excel date format and not in text format...You can
custom format that to display date in any format along with the time for
example m/d/y hh:mm:ss and then the normal sort would sort the dates in
sequence..

--
Jacob


"adammled" wrote:

> I have a single column of data that includes dates in two formats:
> mddyy
> mddyy hh:mm
>
> I tried using the Data>Text-to-Columns... with mdy to change them to dates.
> It worked for the mddyy data, but it messed up the mddyy hh:mm data.
>
> I need to convert these so I can sort them by year>month>day>hour>minute.
 | 
Pages: 1
Prev: Permutations with conflicting groups
Next: Counting strings of consecutive numbers in a column