Converting numbers into time hh:mm:ss

[vani2004]

Below is a export of time from JD Edwards erp system - I can't able to convert them into time. this is HH:MM:SS. I tried using format cells but it's giving me date and time (with 00.00.00). When I convert below numbers I am expecting to see only HH:MM:SS (Not date and time together). Any help will be appreciated. Thank you

Time Created
60700
64500
60600
102500
141600
82700

[Jonmo1]

Try

=TEXT(A1,"00\:00\:00")+0

Format the formula cell as a time.

[vani2004]

You're the Man! Thank you very much...that's solved the problem!

[Jonmo1]

You're welcome.

[Shareez Saleem]

Another Solution
Assume the "60700" is Cell A1: Use the below formula in B1 or wherever you want
=TEXT(CONCATENATE(IF(LEN(A1)=5,CONCATENATE(0,LEFT(A1,1)),LEFT(A1,2)),":",IF(LEN(A1)=5,MID(A1,2,2),MID(A1,3,2)),":",RIGHT(A1,2)),"HH:MM:SS")