time help

[#1]

Hi,

i have a time field (well several), that are in the format of :

9.27527777777

the 9 is the number of hrs and the .27 is a fraction of the remainder. so the .27 is just over quarter which equals 16 minutes.

so the actual time is 09:16.

Does anyone know how i can get this to show as the correct time in qlikview please?

[Gysbert_Wassenaar]

Divide by 24 and set the number display to Time. For example try this in a text box: =time(9.27527777777/24,'hh:mm')

[#3]

Hi Gysbert,

That gives me 0.3864.

if i remove the formatting for that field from the script then the number i get is in seconds, i.e.

33391

is there a way i can get the time from that?

[#4]

found the answer thanks

=interval(TIMEFIELD/86400,'hh:mm:ss')