close

Privacy guaranteed - Your email is not shared with anyone.

Welcome to Glock Talk

Why should YOU join our Glock forum?

  • Converse with other Glock Enthusiasts
  • Learn about the latest hunting products
  • Becoming a member is FREE and EASY

If you consider yourself a beginner or an avid shooter, the Glock Talk community is your place to discuss self defense, concealed carry, reloading, target shooting, and all things Glock.

sorting data in excel

Discussion in 'Tech Talk' started by k9medic, Dec 22, 2010.

  1. k9medic

    k9medic

    1,439
    88
    Sep 16, 2000
    at an LZ near you
    I need to sort some date/time data into a graph in excel 2003.


    Basically the date looks like this in the cell

    12/14/2010 18:50

    I need to get rid of the date leaving only the time.

    any ideas how to do this?
     
  2. RottnJP

    RottnJP Lifetime Member

    1,945
    0
    Feb 1, 2005
    CT
    Try reformatting it to be just the time, first. Right click, and select "Format cells" and it'll tell you you have a custom format that includes date and hours and minutes. Select a format that "hh:mm"

    Try sorting on that. It may or may not work- Depends if it still uses the data you have formatted out of view. Probably won't work, but worth a try as a easy way to do it.

    If that doesn't work, you need to parse the data field.

    Select "Data" then "Text to columns"
    Select "Delimited" and then check the box for "space"

    Interestingly, the data field in my version of excel, 2003, acts like 12-hour time, even though its displayed as a 24-hour clock. So doing the above parses off a "PM" and turns the remaining time field into an "AM" Odd, and stupid. Shoudln't do that. See what your version of excel does.

    If it turns it into a morning time, we can add the "PM" back into the field you want, but I need to look up how do do that later- In the middle of something now. (it's called "concatenating") if you want to check the help menu.
     


  3. RottnJP

    RottnJP Lifetime Member

    1,945
    0
    Feb 1, 2005
    CT
    Glad to hear it worked out easy for you!