Formula to remove date in cell that has date & time in it

[IneedHel]

I have a column that has the date & time in the same cell and I want to remove the date and leave the time

Current Example

[TABLE="width: 113"]
<tbody>[TR]
[TD="class: xl65, width: 113"]01/01/2018 03:40:34[/TD]
[/TR]
</tbody>[/TABLE]

What I need is this

03:40:34

 

[jtakw]

Hi,

If your date & time values are True Date/Time values:

Book1
	A	B	C
1	1/1/2018 3:40:34		3:40:34
Sheet38

Cell Formulas
Range	Formula
C1	=TIME(HOUR(A1),MINUTE(A1),SECOND(A1))

Format result cell as h:mm:ss

 

[dreid1011]

Or even this:

=MOD(A1,1)