Converting Times

[carl]

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.

 

[ryguy7272]

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--

 

[David Biddulph]

=TIME(INT(A2/10000),MOD(INT(A2/100),100),MOD(A2,100))+B2/(24*3600*1000)

 

[Teethless mama]

=TEXT(A2,"00\:00\:00")+B2/86400000

Format cell as: h:mm:ss.000

 

[David Biddulph]

That doesn't deal with the milliseconds in column B, and have you looked at
what it does with 103015 as a column A time input?
[And being a text string result, some further calculations wouldn't work.]