Change Number to hh:mm:ss Format

[F718772]

Hi Team, i am a beginner to the Alteryx world and would want help with a couple of things. For now, I want someone to help me to change the number format to hh:mm:ss format which is the time formata

[PhilipMannering]

When you say "number format", do you mean number of seconds or something else?

[rzdodson]

@F718772 assuming that you are referencing the hour of the day (1 = 1AM, 2 = 2AM, etc.). If so, here is one formula based solution.

In the formula, I am handing the Byte-formatted hour field as a string with the ToString syntax so it can be concatenated with other text strings to produce the desired format.

[F718772]

Thank you for your responses. I have the number format like a decimal number (12) i want to change the format to 12:00:00 (hh:mm:ss) format is there a way we can do that ?

[PhilipMannering]

Yep. It looks like you can use the Formula Tool,

ToDateTime([Field1]/24)

And save the type as "Time". Example attached.