Num to time

[stabben23]

Hi,

I have a num value =2 this is really 00:00:02 on the clock. I also have 92433 which is 09:24:33

I want the field to be formated as a time value like hh:mm:ss. SQL code or in qlikview is OK.

[MarcoWedel]

Hi,

another solution:

LOAD *,
    Time(Mod(val,100)/86400+Mod(Div(val,100),100)/1440+Div(val,10000)/24) as Time
INLINE [
    val
    113
    1256
    211318
    144036
    2
];

hope this helps

regards

Marco

[MarcoWedel]

... and one more:

Time(Time#(Num(val, '000000'), 'hhmmss'),'hh:mm:ss')

hope this helps

regards

Marco