Convert date/time to text
Hi
You could use a helper column with =MOD(A2,1) in it and sort on that.
Hope this helps.
Andy.
"Pam" wrote in message
...
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?
|