Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Formatting conundrum

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm currently trying to convert a cell which contains the number of seconds into another cell which show the seconds as minutes and seconds using the following formula:

    =QUOTIENT(C2,60)&MOD(C2,60)

    where C2 is the cell containing the number of seconds I want to convert. My problem is that the formula works well but I've found now that I cannot display the results as mm:ss which is what I'd like.

    Is anyone able to help me?

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-12 03:48, specky wrote:
    I'm currently trying to convert a cell which contains the number of seconds into another cell which show the seconds as minutes and seconds using the following formula:

    =QUOTIENT(C2,60)&MOD(C2,60)

    where C2 is the cell containing the number of seconds I want to convert. My problem is that the formula works well but I've found now that I cannot display the results as mm:ss which is what I'd like.

    Is anyone able to help me?
    Try formula = =C2/(60*60*24)

    and custom format cell as "mm:ss"


    Kind Regards,
    Ivan F Moala From the City of Sails

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Cheers - worked a treat.

Some videos you may like

User Tag List

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
  •