Convert number to time format

[markgraham123]

Hi,

Here is my sample data:

I want to convert number to hh:mm:ss format.

Please see attached app.

Any help is highly appreciated.

311 - 03:11:00

1258 - 12:58:00

84743 - 08:47:43

[Anil_Babu_Samineni]

It's already been Assume Answered. Not sure, Whether you got to work or not. Perhaps this?

Alt(Date(Date#(Value, 'hmm'),'hh:mm:ss'),Date(Date#(Value, 'hhmm'),'hh:mm:ss'),Date(Date#(Value, 'hhmmss'),'hh:mm:ss'))

OR

LOAD Value, Len, Pick(Match(Len, 3,4,5), Date(Date#(Value,'hmm'), 'hh:mm:ss'),Date(Date#(Value,'hhmm'), 'hh:mm:ss'),Date(Date#(Value,'hhmmss'), 'hh:mm:ss')) as Time;

LOAD *, Len(Value) as Len Inline

[

Value

311

1258

84743

];