convert a text field of numbers to a time

[drohm002]

Hello, in the example below, how do i convert ACQUISITIONTIME of 163821.556552 to 16:38:21?

i already tried Time(Time#(ACQUISITIONTIME, 'HHMMSS'), 'HH:MM:SS') as FormattedTime

[robert_mika · Accepted solution]

Try

Time(Time#(Num(Floor(163821.556552), '000000'), 'HHmmss'), 'HH:mm:ss')

[georgedevries]

Or you can try this:

Time(Timestamp#(Round(ACQUISITIONTIME),'hhmmss'),'hh:mm:ss')