=TIME(INT(M1/10000),INT(MOD(M1,10000)/100),MOD(M1,100))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Denham" wrote in message
...
Hello,

I have a file that puts various time stamps in a column. Such as 173236
forand 93527. I want to know how you can display the numbers as the 24
hours.
Like this
(17:32:36) (09:35:27).

Notice the orginal text outputs either 5 characters or 6 depending either
if
its before 12 pm or after 12 pm. But the final result after the conversion
should be 6 characters, (with a leading zero if before 12 PM).

Any thoughts?

Thanks in advance,