How about:

=TIME(($B1-MOD($B1,10000))/10000,(MOD($B1,10000)-MOD($B1,100))/100,MOD($B1,100))-TIME(($A1-MOD($A1,10000))/10000,(MOD($A1,10000)-MOD($A1,100))/100,MOD($A1,100))

OR

=TIME(MID(TEXT($B1,"000000"),1,2),MID(TEXT($B1,"00 0000"),3,2),MID(TEXT($B1,"000000"),5,2))-TIME(MID(TEXT($A1,"000000"),1,2),MID(TEXT($A1,"000 000"),3,2),MID(TEXT($A1,"000000"),5,2))


"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