topic Re: Convert minutes into time. in QlikView

Convert minutes into time.

Thu, 18 Sep 2014 13:08:52 GMT

Hi everyone,

suppose

I have a field name minutes or variable $(minutes).

I am looking to convert into time. (format hh:mm:ss.)

let me know~ master~

MarcoWedel — Thu, 18 Sep 2014 13:11:49 GMT

Time( $(minutes)/(60*24), 'hh:mm:ss')

anbu1984 — Thu, 18 Sep 2014 13:19:35 GMT

=Time(Time#(Minutes,'mm'))

Anonymous — Thu, 18 Sep 2014 13:22:23 GMT

time(time#($(minutes),'mm'), 'hh:mm:ss')

jagan — Thu, 18 Sep 2014 13:24:05 GMT

Hi,

Try like this

=Time(Time#(variableName,'mm'), 'hh:mm:ss')

=Time(Time#(FileldName,'mm'), 'hh:mm:ss')

Regards,

Jagan.

chriscammers — Thu, 18 Sep 2014 13:29:18 GMT

Also try

=Interval($(vMinutes)/(60*24),'d hh:mm')

This will give you a number of days, hours and minutes.

Thu, 18 Sep 2014 15:22:36 GMT

time#(variablename,hh:mm:ss)