convert 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

[Chanty4u]

Hi 

Try this 

Time(

    Time#(Floor(Num(ACQUISITIONTIME)), 'HHMMSS'),

    'hh:mm:ss'

) as FormattedTime

[marcus_sommer · Accepted solution]

A converting worked only if the specified format-pattern is absolutely identically to the values. It means in your case the milliseconds needs to be removed which might be done by numeric values with a rounding and by strings with any string-function. Further the format-pattern is case-sensitive. Therefore try it with:

Time(Time#(subfield(ACQUISITIONTIME, '.', 1), 'hhmmss'), 'hh:mm:ss') 

[Nagaraju_KCS]

try this 

=Time(Time#((Floor(163821.556552)), 'hhmmss'), 'hh:mm:ss')