Results 1 to 6 of 6

Convert seconds to time display HH:MM:SS

This is a discussion on Convert seconds to time display HH:MM:SS within the Excel Questions forums, part of the Question Forums category; Is there any relativley easy way to take a number of seconds, say 105499, and convert it to HH:MM:SS? I ...

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    9

    Default

    Is there any relativley easy way to take a number of seconds, say 105499, and convert it to HH:MM:SS? I know the answer is 29:18:19, but the report generator I use exports in seconds only, and I need HH:MM:SS.

  2. #2
    y2k
    y2k is offline
    Board Regular
    Join Date
    Feb 2002
    Location
    Ireland
    Posts
    133

    Default

    Format the cell that contains the value as hh:mm:ss by choosing format cells and choosing custom from the list ont he left. On the right, choose hh:mm:ss. I don't think I've explained myself very well so I hope you know what I mean?????

  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582

    Default

    Hi Joe

    If your seconds are C1 use:


    =C2/(1440*60)

    And custom format as [h]:mm:ss




  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    9

    Default

    Actually, that was one of the first things I tried, and it just returns 00:00:00.

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    1,706

    Default

    Hiya,

    Step 1: Divide your seconds by 86400 (easiest way might be to copy a cell with 86400 and then hit paste specialdivide over your range).

    Step 2: Format CellsTime and you'll want to use the "37:30:55" choice. The custom format "hh:mm:ss" will only recycle numbers over 24 hours. I'm sure there's a custom format you could also choose, but the above is already in the listings for time anyway.

    Hope that helps,
    Adam S.

  6. #6
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582

    Default

    On 2002-03-19 07:08, joe77 wrote:
    Actually, that was one of the first things I tried, and it just returns 00:00:00.
    Joe:

    =C2/(1440*60)

    And custom format as [h]:mm:ss

    Does work.

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