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.

    Guest, Dec 25, 2004
    1. Advertisements

  2. Guest

    Ragdyer Guest

    This is for display only:
    With seconds in A1:

    =INT(A1/60)&" Min "&MOD(A1,60)&" Sec"
    Ragdyer, Dec 25, 2004
    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
    JE McGimpsey, Dec 25, 2004
  4. =A1/86400

    Custom time format the formula cell as:

    Aladin Akyurek, Dec 25, 2004
    1. Advertisements

Ask a Question

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.