Convert data into proper time format

26:47:00 -> 1/1/1900 2:47:00 AM
:00 -> :00
12:49 -> 12:49:00 PM
:00:00 -> :00:00
1:15 -> 1:15:00 AM
:11 -> :11

I have the above data in A1:A6. Text written next to "->" is how it is
shown in the formula bar. I want to convert it into [hh]:mm:ss format.

The result I want in B1:B6 is show below. How can I convert?

26:47:00
00:00:00
00:12:49
00:00:00
00:01:15
00:11:00

You'll have to change the values that begin with : to 0:
Then format Cells->Time -> 37:30:55

"[email protected]" wrote:

> 26:47:00 -> 1/1/1900 2:47:00 AM
> :00 -> :00
> 12:49 -> 12:49:00 PM
> :00:00 -> :00:00
> 1:15 -> 1:15:00 AM
> :11 -> :11
>
> I have the above data in A1:A6. Text written next to "->" is how it is
> shown in the formula bar. I want to convert it into [hh]:mm:ss format.
>
> The result I want in B1:B6 is show below. How can I convert?
>
> 26:47:00
> 00:00:00
> 00:12:49
> 00:00:00
> 00:01:15
> 00:11:00
>
>