Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculating time

    Excel 2000. I need to add minutes and seconds of cell phone use to minutes and seconds of radio use. I can't figure out how to do it so that if the answer ends up in hours and minutes the result shows as minutes and seconds. Help!!

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating time

    Create a custom format of [m]:ss (with the brackets around the m)and use this format on the cell where the sum is located.
    Legare Coleman

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating time

    Thank you kind sir. Perfect and so fast! Again, many thanks.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating time

    Thank you thank you thank you. Perfect and so fast! Again, many thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •