topic Re: time help in QlikView

time help

Tue, 19 Feb 2013 17:19:13 GMT

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 — Tue, 19 Feb 2013 19:16:33 GMT

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

Tue, 19 Feb 2013 19:32:46 GMT

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?

Tue, 19 Feb 2013 19:51:33 GMT

found the answer thanks

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