Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Sorting


  • Please log in to reply

#1
Banjoplucker

Banjoplucker

    New Member

  • Member
  • Pip
  • 2 posts
Hello,

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 :tazz: ;)
  • 0

Advertisements


#2
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
what program are you in?
  • 0

#3
Banjoplucker

Banjoplucker

    New Member

  • Topic Starter
  • Member
  • Pip
  • 2 posts
Excel! Sorry!
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP