Converting Times
 

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.

Converting Times
 

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.

Converting Times
 

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

"carl" wrote in message
...
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.

Converting Times
 

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

Format cell as: h:mm:ss.000


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

Converting Times
 

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.]
--
David Biddulph

"ryguy7272" wrote in message
...
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)

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