topic Re: convert text field of numbers to a time in App Development

convert text field of numbers to a time

drohm002 — Thu, 12 Feb 2026 20:37:00 GMT

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

Re: convert text field of numbers to a time

Chanty4u — Fri, 13 Feb 2026 06:19:01 GMT

Try this

Time(

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

'hh:mm:ss'

) as FormattedTime

Re: convert text field of numbers to a time

marcus_sommer — Fri, 13 Feb 2026 06:50:29 GMT

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')

Re: convert text field of numbers to a time

Nagaraju_KCS — Fri, 13 Feb 2026 08:13:31 GMT

try this

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