Date in Time Cell - need to remove it. Please Help!

[gyckl111]

Hi

We have an issue whereby we have a date in the same cell as time.
We only need the time and have tried reformatting the cell to time only and cutting the time out with a right(a1,8) formula but it doesnt seem to work.
Any help much appreciated !!! (example below)

24/02/2013 01:30:00 (we have this)
</SPAN>
01:30:00 (but need this)</SPAN></SPAN>


Many Thanks

Chris

 

[VoG]

Try

=MOD(A1,1)

and format as Time.