Convert Timestamp to time only

[evansabres]

I have a field 'ActivityDate' that appears as such: 2019-12-29 19:65:47.330   I want to convert this to time, specifically AM/PM time format. Ideally, I want to do this in the script, how can I achieve this?

[Or · Accepted solution]

I think you'd have two options here, both of which should work:

1) MakeTime(Hour(YourTime),Minute(YourTime),Second(YourTime))

2) Time(Frac(YourTime))

Either one can be further formatted, of course.