Date & Time Question
Have you tried that, Kevin? Did it work? If so, which version of Excel?
Hints: Does sort base its results on the cell contents or on what is
displayed? Doe display format affect the contents?
--
David Biddulph
"kevcar40" wrote in message
ps.com...
i have assumed your data is in column A and your first cell is A1
Select Comn B and format it HH:MM
in cell b1 = A1
you can now either copy and paste the values to adifferent column to
sort or sort where they are
use the sort button on the tool bar
hth
kevin
On 30 Oct, 12:41, sot wrote:
I have a list with a field in that the date and the time and these cells
are
in the date and time format. (dd/mm/yyyy hh:mm). I need to be able to
use
the time part of the data on its own and sort it into time order. Is
this
possible?
|