Date Time format to Time

[AMDalton]

This feels as though it should be quite easy but here I am. 

I want to change date time to remove the date and keep the time. 

So

From

13/05/2024 12:30:00  

to 
12:30:00

[alexnajm]

Formula should work since it looks like it’s in a string format!

Regex_Replace([Field], “.+\s(.+)” , “$1”) 

OR 

Right([Field],8)

[Qiu]

@AMDalton 

We can also use the straightforwar approach DateTime Parse, or use the Space as delimeter. 😂

[kamal03]

Another way to do this is to use a formula tool.

[aatalai]

If the data is already in time date format you could also put this into the formula tool

datetimetrim([field],'msec')