I'm not exactly sure what you are after, but maybe this will do it for you:
=LEFT(A2,1)&":"&MID(A2,2,2)&":"&RIGHT(A2,2)

Regards,
Ryan--

--
RyGuy


"carl" wrote:

My Time Data is in ColA and B. I am trying to find a formula for ColC. I also
need to be able to add and subtract ColC.


Time MilliSeconds Time2
93015 1 9:30:15.001 AM
93015 10 9:30:15.010 AM

Thanks You In Advance.