Convert time format from HH:MM:SS:FFn to HH:MM - HANA

Hello All,

I'm new to HANA modelling and I want to convert a time stamp for a column from the format 'HH:MM:SS:FFn' to HH:MM (only hours and minute).

I tried to create a calculated column on top of the actual timestamp and tried various functions. But none works.

Below is actual time stamp column and I'm trying to convert it into HH:MM. Is this possible?

Thanks,

Nivetha