time format from a CSV file

[TJHardcore14]

Hi,

just registered however have had massive amount of help from answered questions in the past.

ok I have a table s below

Column A1-A3
81616
111056
32251

I need column B1-B3 to end up with this format 00:00:00

I have tried formatting the cells with no joy, i have tried several ways

Please can you help

 

[ranman256]

use this function after import to convert:
usage: =Cvt2Time(A1)

Function Cvt2Time(ByVal pvNum)
  If Len(pvNum) = 5 Then pvNum = "0" & pvNum
  Cvt2Time = Left(pvNum, 2) & ":" & Mid(pvNum, 3, 2) & ":" & Right(pvNum, 2)
End Function

 

[joeu2004]

Column A1-A3
81616
111056
32251
I need column B1-B3 to end up with this format 00:00:00

If you expect the following results:
8:16:16
11:10:56
3:22:51

enter the following formula into B1 and copy down:
=--TEXT(A1,"00\:00\:00")

formatted as Custom [h]:mm:ss .

I recommend that instead of h:mm:ss on the off-chance that your input represents more than 23:59:59.

 

[TJHardcore14]

Excellent Joeu2004, thank you for this, the expected outcome has worked.

 

[TJHardcore14]

thanks for this ranman256 but needed formula not VBA.