Enter times greater than 24:00 in Excel...

Discussion in 'Mac Apps and Mac App Store' started by aaronptrck, Sep 26, 2008.

  1. aaronptrck macrumors member

    aaronptrck

    Joined:
    Jun 29, 2007
    Location:
    California
    #1
    I am inputing all of my school's Cross Country times into a 2008 Excel Doccument, and some of the times are greater than 24:00, in this instance Excel reformats it to display the time of day (Ex. 24:12 formats to 0:12) I have tried to go to the Format Cells option, but I don't see a way to enter times without using decimals (24:12.0) is there a way I can display a time simply as: 24:12 (or a time greater than 24:00)???

    Thanks
     
  2. klaxamazoo macrumors 6502

    Joined:
    Sep 8, 2006
    #2
    Select the cell, right click and select "format cells"
    In the first tab, "Number" go to the "Category" menu and select "Text"

    This will leave keep excel from reformatting the numbers you put; however it won't let you do any math on the values.

    You could also try and make your own custom field.
     
  3. Julien macrumors G3

    Julien

    Joined:
    Jun 30, 2007
    Location:
    Atlanta
    #3
    I believe that the time format also serves as a calculation for dates and days. In order to keep dates and days straight it must be limited to 24.
     
  4. aaronptrck thread starter macrumors member

    aaronptrck

    Joined:
    Jun 29, 2007
    Location:
    California
    #4
    Thanks a lot worked perfectly!



     

Share This Page