Time format (example: 00:00.00)

Hi there,

I have some problems with my time format.

I want this format : mm:ss.ff example 01:22.98
Which format or macro can do that, the user is typing the time value starts with minutes:second.hundredth of a second.
When she/he is typed the six characters she/he hit enter button and the format is jumped to 00:00.00 format style.

Example:

user type:

012099 -> hit enter -> the format change to this : 01:20.99

How can I do this?
I hope it's possible.

Thanks with advance.

ps: Sorry my English

Hi

Firstly, thanks for the quick answer.

Secondly, I can't use macro because I am noob in Excel. I tried in many ways. I'm reading a lots how to implement macro to the Excel, but I can't to this.
I'm writed a program who only can read the time score only this format "00:00.00". In my write program can't accept other format. beacuse who is ordered said he need only this format.

May I upload the xls and you implement the macro?
What I need in the worksheet :

In the worksheet where I needed this format I painted orange color.

So all in all:

Where the cells are orange, the user can't write other than 00:00.00. The numbers can change but the ":" and "." characters can't.

I said again thank you very much.

Please help me.

Very very thanks.

Here the attached file:
https://drive.google.com/open?id=0Bz...kFxLThmeHF2enM

Hi,

it's works. It's enough for me.

Big thanks.