Custom time format

[Bobby]

I need help again, still can't get this to work.
I using the custom time format of
0":"00
and this will give me 2:35 when I just type 235 in the cell
but my problem is now when I type in only seconds like 35
I get this 0:35. How can I omit the leading zero and get this
:35 just the seconds?
I tried most every combo I can think of.

Thanks bobby

 

[Dave Peterson]

How about:
#":"00

But I think I'd enter the values as time (including the colon). You'll be able
to do more things (arithmetic) with that value.

Chip Pearson has some code that will do the change for you at:
http://www.cpearson.com/excel/DateTimeEntry.htm

 

[JE McGimpsey]

One way:

Format/Cells/Number/Custom #":"00

 

[Bobby]

Thanks - a - bunch...
just what I wanted.

Bobby

One way:

Format/Cells/Number/Custom #":"00

 

[Bobby]

Thanks - a - bunch...
just what I wanted.

Bobby

How about:
#":"00

But I think I'd enter the values as time (including the colon). You'll be able
to do more things (arithmetic) with that value.

Chip Pearson has some code that will do the change for you at:
http://www.cpearson.com/excel/DateTimeEntry.htm