One way:

=REPLACE(REPLACE(A1,LEN(A1)-1,,":"),LEN(A1)-3,,":")+0

Format the formula cells as time.

HTH

Jason
Atlanta, GA

-----Original Message-----
Hello experts.

I have data as follows:
94423
94717
100523
101142

Is there a formula I could apply to change the numbers
to time:
9:44:23
9:47:17
10:05:23
10:11:42

Thank you so much for your help.


--
MB
.