topic Re: Days:Hours:Minutes format in QlikView https://community.qlik.com/t5/QlikView/Days-Hours-Minutes-format/m-p/1205839#M387567 <HTML><HEAD></HEAD><BODY><P>May be</P><P></P><P><STRONG>Interval(FieldName, 'D:h:mm')</STRONG></P></BODY></HTML> Wed, 02 Nov 2016 20:04:45 GMT sunny_talwar 2016-11-02T20:04:45Z Days:Hours:Minutes format https://community.qlik.com/t5/QlikView/Days-Hours-Minutes-format/m-p/1205838#M387566 <HTML><HEAD></HEAD><BODY><P>Hello All -</P><P></P><P>If I have a bucket of minutes, how do i get it formatted to:</P><P></P><P>Days:Hours:Minutes</P><P></P><P>I assume it's the interval function, but can't get it to work...</P><P></P><P>Thanks!</P><P></P><P>mike</P></BODY></HTML> Wed, 02 Nov 2016 20:01:43 GMT https://community.qlik.com/t5/QlikView/Days-Hours-Minutes-format/m-p/1205838#M387566 mikecrengland 2016-11-02T20:01:43Z Re: Days:Hours:Minutes format https://community.qlik.com/t5/QlikView/Days-Hours-Minutes-format/m-p/1205839#M387567 <HTML><HEAD></HEAD><BODY><P>May be</P><P></P><P><STRONG>Interval(FieldName, 'D:h:mm')</STRONG></P></BODY></HTML> Wed, 02 Nov 2016 20:04:45 GMT https://community.qlik.com/t5/QlikView/Days-Hours-Minutes-format/m-p/1205839#M387567 sunny_talwar 2016-11-02T20:04:45Z Re: Days:Hours:Minutes format https://community.qlik.com/t5/QlikView/Days-Hours-Minutes-format/m-p/1205840#M387568 <HTML><HEAD></HEAD><BODY><P>would that work with an expression too?</P></BODY></HTML> Wed, 02 Nov 2016 20:05:24 GMT https://community.qlik.com/t5/QlikView/Days-Hours-Minutes-format/m-p/1205840#M387568 mikecrengland 2016-11-02T20:05:24Z Re: Days:Hours:Minutes format https://community.qlik.com/t5/QlikView/Days-Hours-Minutes-format/m-p/1205841#M387569 <HTML><HEAD></HEAD><BODY><P>I believe so... is it not working?</P></BODY></HTML> Wed, 02 Nov 2016 20:06:37 GMT https://community.qlik.com/t5/QlikView/Days-Hours-Minutes-format/m-p/1205841#M387569 sunny_talwar 2016-11-02T20:06:37Z Re: Days:Hours:Minutes format https://community.qlik.com/t5/QlikView/Days-Hours-Minutes-format/m-p/1205842#M387570 <HTML><HEAD></HEAD><BODY><P>I worked! Just one adjustment... we needed to divide by 1440 (minutes in a day) to get the right value.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 02 Nov 2016 20:15:46 GMT https://community.qlik.com/t5/QlikView/Days-Hours-Minutes-format/m-p/1205842#M387570 mikecrengland 2016-11-02T20:15:46Z Re: Days:Hours:Minutes format https://community.qlik.com/t5/QlikView/Days-Hours-Minutes-format/m-p/1205843#M387571 <HTML><HEAD></HEAD><BODY><P>another one:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14781274438628548 jive_text_macro" jivemacro_uid="_14781274438628548"> <P>Interval(Interval#(yourminutes,'m'),'d:hh:mm')</P> </PRE><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Wed, 02 Nov 2016 22:57:31 GMT https://community.qlik.com/t5/QlikView/Days-Hours-Minutes-format/m-p/1205843#M387571 MarcoWedel 2016-11-02T22:57:31Z