DECIMAL to TIME how?

[Dimitri_Zbanok]

Hi guys, i have this problema.

I have one column in DECIMAL TIME (4,5) and need convert this decimal in column 8 to TIME HH:MM

¿How?

[Rafael_ANEIC-PY]

Hello @Dimitri_Zbanok , welcome to our community !

I saw this tip on the time() help article, it looks like just what you need:

Here’s the expression:

(
  TIME(
    CONCATENATE(
      MOD(FLOOR([Hours]), 24),
      ":",
      FLOOR(MOD(((60 * 60) * [Hours]), (60 * 60)) / 60),
      ":",
      MOD(((60 * 60) * [Hours]), 60)
    )
  )
  - "00:00:00"
)
+ (FLOOR([Hours] / 24) * 24)

And here’s the link: https://help.appsheet.com/en/articles/2357323-time

[Dimitri_Zbanok]

how add this?