Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Apr 2009
    Posts
    114
    Thanks
    18
    Thanked 0 Times in 0 Posts
    Hello All,
    I need to format time to display as hh:mm:ss so when I type in 123045 it would display as 12:30:45. I tried the custom number format and time format in Excel but did not receive the desired results. I am using Excel 2007.

    Thanks in advance for any assistance you can provide,
    MOstate

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    I think you will have to separate the time with colons 12:30:45, otherwise Excel interprets the time as the date.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Check out MS MVPs Quick Time Entry macros http://www.cpearson.com/excel/DateTimeEntry.htm if you want code to convert to time

    Steve

  4. #4
    2 Star Lounger
    Join Date
    Apr 2009
    Posts
    114
    Thanks
    18
    Thanked 0 Times in 0 Posts
    Thanks so much for the responses. Steve I copied the code and it works great but it displays AM or PM. Do you know how I would edit it to just show the time?

    Thanks Again!!

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    That is a formatting issue and unrelated to the code.

    Select the cells
    Format - Cells
    Number(tab)
    Category: Custom
    Type: hh:mm:ss
    [ok]

    Steve

  6. #6
    2 Star Lounger
    Join Date
    Apr 2009
    Posts
    114
    Thanks
    18
    Thanked 0 Times in 0 Posts
    Works like a charm thanks so much to everyone

Posting Permissions

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