Convert 231045 to 11:10:45 PM Time Format in Qlik Sense

[Dharanidharan_Qlik]

Hi, 

I get a time field containing values like 231045  Need to convert this to 11:10:45 PM.

Could someone can help. Thanks.

Few examples:

112345 to 11:23:45 AM

162232 to 04:22:32 PM

[Clement15]

Hello, you can use this formula.

time(Time#(timetemp,'hhmmss')) as Time

Here is an example and the result :

[BrunPierre · Accepted solution]

Considering your preference for a 12-hour format, an adjustment to @Clement15 's Time(Time#(Timetemp, 'hhmmss'), 'hh:mm:ss TT') as Time