convert a number in time format

Hi
After an exhaustive search here in forum and google, I didn´t find any solution to this issue.

Here's my problem:

i received a file with time data in this format:
003457 - Which means 00h 34m 57s
012554 - Which means 01h 25m 54s
035839 - and so on...
042510
054439
063532
065722
075211
075612
101740
102817
105527
105715

to convert I used the following formula
=IF(A1>9999,TIME(LEFT((RIGHT(N2,6)),2),LEFT((RIGHT(N2,4)),2);RIGHT(N2,2)),TIME(0,LEFT((RIGHT(N2,4)),2),RIGHT(N2,2)))
But it doesn't work in all conversions
003457 - 00h 34m 57s - YES
012554 - 01h 25m 54s - WRONG 12h 25m 54s
035839 - 03h 58m 39s - WRONG 11H 58m 39s
042510 - 04h 25m 10s - WRONG 18H 25m 10s
054439 - 05h 44m 39s - WRONG 06H 44m 39s
063532 - 06h 35m 32s - WRONG 15H 35m 32s
065722 - 06h 57m 22s - WRONG 17H 57m 22s
075211 - 07h 52m 11s - WRONG 03H 52m 11s
075612 - 07h 56m 12s - WRONG 03H 56m 12s
101740 - 10h 17m 40s - YES
102817 - 10h 28m 17s - YES
105527 - 10h 55m 27s - YES
105715 - 10h 57m 15s - YES

So, what am I doing wrong?
Thanks very much in advance.

Ioncila

Try

=TEXT(--N2;"00\:00\:00")

Hi Jason
PERFECT!
AND TOO MUCH SIMPLIER.

Thank You Very much
Ioncila

Originally Posted by FDibbins

@ Jason, your formula gives a text answer, that is not really time, although it looks like it is. As a text, copy that to all the "numbers" provided, and try and sun the total

I was aware of that, Ford, given that the source data appeared to be in text format, I left the output the same. The formula can be coerced to numeric values with a double unary.

Hi
First, I thank you all for the feedback and discussion about my issue.
But, for the record, I didn't put my problem in a correct way, although Jason got it to the point I needed.

The data to convert (ex, 003457) means the time completation of a task (in this case, 34m 57s), and not a timestamp.

Jason's suggestion did answer to my doubt. What I didn't refer is that I added a small change to formula to get numeric results:
=VALUE(TEXT(--N2;"00\:00\:00"))

Once again
Thank you very much

Ioncila