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. =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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jeff

    Convert seconds into hours:minutes:seconds

    Jeff, Aug 9, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    933
    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:
    293
    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:
    508
    Ron Rosenfeld
    Dec 9, 2004
  4. 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:
    574
    JoeU2004
    Jun 18, 2009
  5. Kathie

    Convert text entered as minutes/seconds to minutes

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

Share This Page