GlockTalk.com
Home Forums Classifieds Blogs Today's Posts Search Social Groups



  
SIGN-UP
Notices

Glock Talk
Welcome To The Glock Talk Forums.

 
  
Reply
 
Thread Tools Display Modes
Old 12-22-2010, 15:38   #1
k9medic
Senior Member
 
k9medic's Avatar
 
Join Date: Sep 2000
Location: at an LZ near you
Posts: 1,627
sorting data in excel

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?
__________________
K9 "Prince" 03/04/05 Goodbye my good friend

Sed quis custodiet ipsos custodes?
k9medic is offline   Reply With Quote
Old 12-22-2010, 18:11   #2
RottnJP
Lifetime Membership
Senior Member
 
RottnJP's Avatar
 
Join Date: Feb 2005
Location: CT
Posts: 1,997
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.
__________________
Outpost Member #69.14159
RottnJP is offline   Reply With Quote
Old 12-22-2010, 20:54   #3
k9medic
Senior Member
 
k9medic's Avatar
 
Join Date: Sep 2000
Location: at an LZ near you
Posts: 1,627
Awesome - It worked. thanks!
__________________
K9 "Prince" 03/04/05 Goodbye my good friend

Sed quis custodiet ipsos custodes?
k9medic is offline   Reply With Quote
Old 01-02-2011, 08:30   #4
RottnJP
Lifetime Membership
Senior Member
 
RottnJP's Avatar
 
Join Date: Feb 2005
Location: CT
Posts: 1,997
Glad to hear it worked out easy for you!
__________________
Outpost Member #69.14159
RottnJP is offline   Reply With Quote

 
  
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump




All times are GMT -6. The time now is 06:19.




Homepage
FAQ
Forums
Calendar
Advertise
Gallery
GT Wiki
GT Blogs
Social Groups
Classifieds


Users Currently Online: 641
190 Members
451 Guests

Most users ever online: 2,672
Aug 11, 2014 at 2:31