Use
=mod(date_time value,1)
& format it as time

If it is a text value, use
=TIMEVALUE(RIGHT(text value,8))
& format it as time

"gb_S49" wrote:

Hmmmm is it possible for a formula to just extract the time aspect?
30/03/2005 14:17:00