Time format (example: 00:00.00)

Hi,
You could try to manage this with Time format.
First make cell where you will enter "012099" as Text formatted, just to keep leading "0".
Then just use formula like

Formula:

=LEFT(A1;2)&":"&MID(A1;3;2)&","&RIGHT(A1;2)

Method which converts number string into timevalue.

First set range's cell format to "mm:ss.00"

In Standard Module.

Function ConvertToTimeVal(myVal As Long) As Double
Dim myStr As String
Dim myMin As Double, mySec As Double, myMili As Double

myStr = Format(myVal, "000000")
myMin = CDbl(Left(myStr, 2)) * 60 * 1000
mySec = CDbl(Mid(myStr, 3, 2)) * 1000
myMili = CDbl(Right(myStr, 2)) * 10

ConvertToTimeVal = (myMin + mySec + myMili) / 1000 / 24 / 60 / 60

End Function

Then in Worksheet module (Change range as needed).

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Count > 1 Then Exit Sub

If Not Intersect(Target, Range("B2:B100")) Is Nothing Then
    If Target.Value = "" Then Exit Sub
    Application.EnableEvents = False
    Target.Value = ConvertToTimeVal(Target.Value)
    Application.EnableEvents = True
End If

End Sub

See attached.

Note: Not fully tested. If you find issue, let me know.

Hmm. If you are not able to implement above. I wouldn't recommend using VBA in your project.

Above is just sample of how it can be implemented. In real-life scenario, you'll need to think how user will input data.

Will they always type it in? Will they copy and paste? What should happen if invalid entry is made? etc etc.

As for my code just copy and paste Function code into Module1, and Worksheet code to Munka1 (code). Change Range("B2:B100") to Range("D9:M48").

Note that data should be entered as numeric string only (ex. 012945).