Results 1 to 2 of 2

Formatting a cell for swim times

This is a discussion on Formatting a cell for swim times within the Excel Questions forums, part of the Question Forums category; I have been trying to format a cell for swim times: mm:ss:## the ## needs to be a number between ...

  1. #1
    New Member
    Join Date
    Jun 2002
    Location
    Lynne
    Posts
    1

    Default

    I have been trying to format a cell for swim times: mm:ss:## the ## needs to be a number between 00 and 99. I have tried customizing etc, but I really don't know what I'm doing. Can anyone help?

  2. #2
    Board Regular
    Join Date
    Jun 2002
    Location
    Abergavenny, Wales, UK
    Posts
    101

    Default

    Hi Lynne

    You are almost there.
    Got to Format=>Number=>Custom and set up the format as mm:ss.00

    You can then enter a time of 1 min 15.83 secs as 1:15.83 and that is how it will display.

    Internally, Excel will still store it as fractions of a day and in the formula bar is will show as 00:01:16

    Any calculations carried out, will add (or subtract) the decimal seconds you have entered correctly.
    --
    Roger Govier
    Technology 4 U

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
  •  


DMCA.com