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

[aaronptrck]

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

 

[klaxamazoo]

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.

 

[Julien]

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.

 

[aaronptrck]

Thanks a lot worked perfectly!

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.