topic Convert Minutes to Time (HH:MM) in QlikView https://community.qlik.com/t5/QlikView/Convert-Minutes-to-Time-HH-MM/m-p/1391664#M810142 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the following number (in minutes):</P><P></P><P>106,2241116089</P><P></P><P>I need to convert it to time format (hh:mm).</P><P></P><P>It would be something like: 01:47</P><P></P><P>Do you know how to do that?</P><P></P><P>Thank you!!!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT microwin88x 2020-11-25T16:16:04Z Convert Minutes to Time (HH:MM) https://community.qlik.com/t5/QlikView/Convert-Minutes-to-Time-HH-MM/m-p/1391664#M810142 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the following number (in minutes):</P><P></P><P>106,2241116089</P><P></P><P>I need to convert it to time format (hh:mm).</P><P></P><P>It would be something like: 01:47</P><P></P><P>Do you know how to do that?</P><P></P><P>Thank you!!!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Convert-Minutes-to-Time-HH-MM/m-p/1391664#M810142 microwin88x 2020-11-25T16:16:04Z Re: Convert Minutes to Time (HH:MM) https://community.qlik.com/t5/QlikView/Convert-Minutes-to-Time-HH-MM/m-p/1391665#M810143 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>=interval(FieldName/24/60, 'hh:mm')</STRONG></P></BODY></HTML> Wed, 18 Oct 2017 15:17:40 GMT https://community.qlik.com/t5/QlikView/Convert-Minutes-to-Time-HH-MM/m-p/1391665#M810143 Anil_Babu_Samineni 2017-10-18T15:17:40Z Re: Convert Minutes to Time (HH:MM) https://community.qlik.com/t5/QlikView/Convert-Minutes-to-Time-HH-MM/m-p/1391666#M810144 <HTML><HEAD></HEAD><BODY><P>Or</P><P><STRONG>=Time((25569 + Round(FieldName/1000) / 86400), 'hh:mm')</STRONG></P></BODY></HTML> Wed, 18 Oct 2017 15:22:18 GMT https://community.qlik.com/t5/QlikView/Convert-Minutes-to-Time-HH-MM/m-p/1391666#M810144 Anil_Babu_Samineni 2017-10-18T15:22:18Z