Converting to time

[Mediaexcel]

Hello!

I regularly import data into an excel sheet, the time column I receive is in the following format:

839
603
1154
1336
734

which is:
08:39
06:03
11:54
13:36
07:34


What macro can I use to convert this column into a time format?


Thanks for your help.

M.E.

[anilsolipuram]

Sub convert_date()
Dim i As Long
Dim temp as variant
For i = Range("A65536").End(xlUp).Row To 1 Step -1
if len(cells(i,1).value)=3 then
temp = "0" & Mid(Cells(i, 1), 1,1 ) & ":" & mid(cells(i,1),2,2)
elseif len(cells(i,1).value)=4 then
temp = Mid(Cells(i, 1), 1,2 ) & ":" & mid(cells(i,1),3,2)
end if

Cells(i, 1).NumberFormat = "dd mmm yyyy"
Cells(i, 1).Value = temp
Next
End Sub

[Mediaexcel]

Thank you!
I adapted it to my spreadsheet and it worked.