Converting Numeric Values (hhmmss) to Times with via

Hello Forum
I have a column with numeric values for time looking like following with wanted result in ():
429 (00:04:29)
501 (00:05:01)
758 (00:07:58)
831 (00:08:31)
954 (00:09:54)
1029 (00:10:29)
1526 (00:15:26)
1941 (00:19:41)
5958 (00:59:58)
10318 (01:03:18)
10620 (01:06:20)

I use below code that originally was for hh:mm but I need seconds as well so added iSec.
What do I do wrong here? I can't get it to show the correct time as the calculation is wrong somehow..
Thanks

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

How about just a formula?

429	0:04:29	B2: =--TEXT(A2, "0\:00\:00")
501	0:05:01
758	0:07:58
831	0:08:31
954	0:09:54
1029	0:10:29
1526	0:15:26
1941	0:19:41
5958	0:59:58
10318	1:03:18
10620	1:06:20

Please Login or Register  to view this content.

Just change the type
Is it to do for the selection or for column "A" ?

Please Login or Register  to view this content.

@PCI
It is actually a range I want to use it with, I have values in two columns H2 and down & I2 and down, can be over 200 000 rows, its part of a code with other things needed so selection is not really the solution here, try to avoid...

I did test it again with your update and it worked, yes it was probably the selection...

Thanks

See next code

Please Login or Register  to view this content.

Very please to help you
Shg's code is very nice ...!
Thx for the rep