And, yet, one more...

=--REPLACE(A1,9,4,"")

By the way, I think you should include the double unary in front of the
string functions you posted in order to convert them to real time values
(which can then be formatted as a Time value); although, to be fair to you,
the OP's posting can be read that a text value should be returned (I just
don't think that is what is he actually wants).

--
Rick (MVP - Excel)


"Jacob Skaria" wrote in message
...
One more...

=LEFT(J29,FIND(":",J29,8)-1)

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

=LEFT(A1,8) and format that to hh:mm:ss

If this post helps click Yes
---------------
Jacob Skaria


"bingo983" wrote:

i have time data with hours, minutes, seconds, and miliseconds. but in
order
to do my calculations, i need to drop the miliseconds. how can i format
this
data so it will only display h:mm:ss?

example: if a cell reads 12:34:55:789, how do i format the cell so the
789
miliseconds drops off, and cell only shows 12:34:55?

i know this can be done in currency and numbers, as you can indicate
how
many decimal places you want. so how do you do it with time?