date time formatting
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: date time formatting

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Can anyone help me with formatting a peculier numeric string? I have data output from a serial device that includes the following date/time string in "yy/mm/dd/hh:mm:ss" ie: "01/04/11/12:22:51"
    I can get excel to format all kinds of date/time combos via custom number formats. Doesn't seem to like this one.
    excel 2k sr-1

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Assuming your data is in Column A
    Run this down Column B
    Format to suit

    =LEFT(A1,8) & " " & RIGHT(A1,8)

    Tom

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi dont see a problem there i would edit thou:

    try

    yy/mm/dd hh:mm:ss

    should work OK! custom format the cell
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks Tom! That takes care of my first stumbling block, seperating the date and time. Wouldn't be a big deal except I will be looking at thousands of them!
    Is there a way I can either rearrange the date to a western standard or convince excel to show it as 2001-Aug-2?

    Allan

    [ This Message was edited by: bagpeople on 2002-04-16 16:51 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com