Time in Excel

[Tom]

I want to format cells so that they represent timing - not time of day, time.
Like race times. 1:54.2 as a harness time. I can't get any typeof formattingto work - everthing turn into a time and date, even when I use custom formatting.
Anyone have any ide to make a simple time format, short of getting rid of Excel and buying a real spreadsheet program? :rolleyes::mad:

[bigmack]

Is you putting the times in manually or automatically?

[bigmack]

I think you need to turn off "conditional formatting" as it's recognizing those as times. Here's Carol Marol to tell you how - Carol

http://www.digitalsurvivors.com/archives/000351.php




And if you get that figured out slide in some in-cell graphs, they're nifty
The shorter the graph the quicker the time

http://lifehacker.com/assets/resources/2006/08/excel_rept2.gif


http://lifehacker.com/software/excel/excel-tip-instant-incell-graphs-193425.php

[DanG]

And if you get that figured out slide in some in-cell graphs, they're nifty
The shorter the graph the quicker the time

http://lifehacker.com/assets/resources/2006/08/excel_rept2.gif


http://lifehacker.com/software/excel/excel-tip-instant-incell-graphs-193425.php

Bigmack;

Cool tip.

Thank you very much!:ThmbUp:

[Tom]

Cool tip on the graphs...I can use that.
But I don't see where CF will help me. I want the numbers as times, but not time.

[bigmack]

I've got bad news Tom - It's your colon.




Use a semicolon instead or, go into format, cell, custom, bla bla bla
Sorry for the technical jargon

[Rpd]

Tom,

If you are just entering it use an apostrophe: '1:52.2

If you are calculating it then you'll have to devise a formula using HOUR()...MINUTE()....SECOND().

If you need help with the exact formula, let me know.