problems with time format in Qlikview

[#1]

Hello everyone!

I tried to show a field ([Cons. Live]) loaded from Excel in the correct time format (i.e. 35.20.40). It's an elapsed time and not a clock time because it's the sum of time sessions. i have used the interval() or interval#() functions but with no success. i see the values in the field as numbers and not as time.

Please can you help me? i'm not expert with Qlikview. Here the extract of my script:

LOAD Member,
[Name and surname] as Nome_cognome,
[Cons. Live] as Ore_sessione,
interval#([Cons. Live],'hh:mm:ss') as Ore_sessione2,
[Cons. Ond] as Ore_sessione_ond,

FROM

here the output:

Ore_sessione
0
0,000694444
0,001388889
0,002083333
0,002777778
0,003472222
0,004166667
0,004861111
0,005555556
0,00625
0,006944444
0,007638889
0,008333333
0,009027778

Thanks,

scapsina

[spsrk_84]

Hi,

LOAD Member,
[Name and surname] as Nome_cognome,
[Cons. Live] as Ore_sessione,
Time([Cons. Live],'hh:mm:ss') as Ore_sessione2,
[Cons. Ond] as Ore_sessione_ond,

FROM

Try the above one

Regards,

Ajay

[#3]

Thank you for your answer!

i have tried but qlikview doesn't show me the time sessions more "big" than 24. I have to visualize sum of time sessions that can exceed the 24 hours.

do you have any ideas?

Francesca