Convert seconds to minutes and seconds in excel

Discussion in 'Microsoft Excel Worksheet Functions' started by Guest, Dec 25, 2004.

  1. Guest

    Guest Guest

    I need a formula which converts seconds to minutes and seconds.

    TY for your help. Happy Holidays.

    Chris
     
    Guest, Dec 25, 2004
    #1

    1. Advertisements

  2. Guest

    Ragdyer Guest

    This is for display only:
    With seconds in A1:

    =INT(A1/60)&" Min "&MOD(A1,60)&" Sec"
    --
    HTH,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------

    "anonymous" <> wrote in message
    news:...
    > I need a formula which converts seconds to minutes and seconds.
    >
    > TY for your help. Happy Holidays.
    >
    > Chris
     
    Ragdyer, Dec 25, 2004
    #2

    1. Advertisements

  3. Guest

    JE McGimpsey Guest

    XL stores times as fractional days, so to convert integer seconds to an
    XL time (minutes and seconds), divide by 24*60*60:

    A1: 123
    A2: =A1/86400

    which will display 2:03 when formatted as [m]:ss


    In article <>,
    anonymous <> wrote:

    > I need a formula which converts seconds to minutes and seconds.
    >
     
    JE McGimpsey, Dec 25, 2004
    #3
  4. Guest

    Aladin Akyurek Guest

    =A1/86400

    Custom time format the formula cell as:

    [mm]:ss

    "anonymous" <> wrote in message
    news:...
    >I need a formula which converts seconds to minutes and seconds.
    >
    > TY for your help. Happy Holidays.
    >
    > Chris
     
    Aladin Akyurek, Dec 25, 2004
    #4

    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Jeff

    Convert seconds into hours:minutes:seconds

    Jeff, Aug 9, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    2,487
    Random
    Aug 9, 2003
  2. bradsmih

    CONVERTING MINUTES AND SECONDS TO MINUTES ONLY

    bradsmih, May 24, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    602
    bradsmih
    May 24, 2004
  3. Guest

    convert seconds to minutes and seconds

    Guest, Dec 9, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    2,801
    Ron Rosenfeld
    Dec 9, 2004
  4. Guest

    Converting hours:minutes:seconds to just minutes

    Guest, Jul 17, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    452
    VBA Noob
    Jul 17, 2006
  5. Guest

    Coverting seconds, to minutes and seconds

    Guest, Aug 4, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    374
    Pete_UK
    Aug 4, 2006
  6. NickBrown419

    How do I change a minutes and seconds as a 2400 time to seconds?

    NickBrown419, Aug 10, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    455
    Lars-Åke Aspelin
    Aug 10, 2008
  7. Cliff

    Need to convert Minutes:Seconds format to minutes with seconds con

    Cliff, Jun 18, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    843
    JoeU2004
    Jun 18, 2009
  8. Kathie

    Convert text entered as minutes/seconds to minutes

    Kathie, May 5, 2010, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    708
    Fred Smith
    May 6, 2010
Loading...