topic Re: Convert calculated number to time in QlikView

Convert calculated number to time

tappij2012 — Fri, 31 Oct 2014 12:52:48 GMT

Hi,

I want to convert a calculated number into a time-format in a table.

For Example:

I've calculated a number: 128, which means 128 minutes.

In time-format it will be: 02:08 [hh:mm].

How can I make that work?

MK_QSL — Fri, 31 Oct 2014 12:54:13 GMT

=Time(Time#(Num#('128','#0'),'m'),'hh:mm')

its_anandrjs — Fri, 31 Oct 2014 13:27:07 GMT

Hi,

You can convert this way

Load

Time( Time#( num(NumberField),'m'),'hh:mm') as NUmField

From Location;

Ex:- any any text box write this expression

=Time( Time#( num('128'),'m'),'hh:mm')

Regards

Anand

tappij2012 — Mon, 03 Nov 2014 13:31:07 GMT

Now I've seen that it count until 23:59 [hh:mm].

After that it counts from 0.

For example:

number 1439 give as result 23:59 [hh:mm]
number 1441 give as result 00:01 [hh:mm] (and not like I wish 24:01 [hh:mm])

How can I solve that?

Regards Robin

anbu1984 — Mon, 03 Nov 2014 13:46:24 GMT

=Floor(1441/60) & ':' & Num(Mod(1441,60),'00')

MK_QSL — Mon, 03 Nov 2014 13:56:46 GMT

=interval(1441/1440,'hh:mm')