No actually you typed it wrong, Brett just copied your error, I had the same
problem <g

Bob


"Lexicon" wrote in message
...
Brett - You just typed the numbers in wrong on your posting - that's
probably
why it didn't work for you!

In formatting, in custom, type in 00:\00:\00 and this should enable you to
input for example 123245 and it will convert automatically to 12:32:45

Niki



"Brett" wrote:

I have a question for you! How do you format a cell with :00:\00:\00? I
tried
creating this custom number format myself, but excel wouldn't allow it.

"Lexicon" wrote:

Please help! I have used the 00:\00:\00 format to input times without
having
to press the colon every time. Now though, when Excel tries to minus
one time
from another, because of the custom format it only recognizes times as
numbers...

e.g. 12:15:30 - 12:14:50

Excel thinks this equals 00:00:80!!

Can anybody help? How do I get it to recognise that the answer is
00:01:20 ?
Thank you