On Sat, 19 Feb 2005 00:07:26 +0100, Aladin Akyurek wrote:

=TEXT(TEXT(A2,"000000"),"00\:00\:00")+0

where A2 houses a value like 94423.

Custom format the formula cell as:

h:mm:ss

I like that approach!

But even simpler:

=--TEXT(A1,"00\:00\:00")


--ron