Please advise with regard to sorting the following format:
dd-mmm-yyyy hh:mm:ssAM/PM
in the same cell/column
I only seem to be able to get it to sort numerically against the "dd" figure rather than by date and the time within the particular date for when the date occurs more than once.
i.e. it only sorts in day order and throws the months and years out of proper date/time order.
Regards
Banjoplucker