topic Re: Time Format in QlikView https://community.qlik.com/t5/QlikView/Time-Format/m-p/745721#M1030348 <HTML><HEAD></HEAD><BODY><P>Thanks Bill for your quick help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Wed, 18 Feb 2015 18:25:25 GMT vikasgupta 2015-02-18T18:25:25Z Time Format https://community.qlik.com/t5/QlikView/Time-Format/m-p/745719#M1030346 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have one straight Table with time format and one field is number of allocated member and i wants to calculate as per example .</P><P>Please find the screenshot for same</P><P>For example I wants to calculate 150:00:00 * 13 = 1950:00:00</P><P>Time for mat excel is hh:mm:ss</P><P></P><P>Thanks</P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/78465_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 18 Feb 2015 18:09:58 GMT https://community.qlik.com/t5/QlikView/Time-Format/m-p/745719#M1030346 vikasgupta 2015-02-18T18:09:58Z Re: Time Format https://community.qlik.com/t5/QlikView/Time-Format/m-p/745720#M1030347 <HTML><HEAD></HEAD><BODY><P>You should be able to adapt this to your needs :</P><P></P><P><EM><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; interval ( interval# ( '150:00:00' , 'h:mm:ss' ) * 13&nbsp; , 'h:mm:ss' )</STRONG></EM></P></BODY></HTML> Wed, 18 Feb 2015 18:19:32 GMT https://community.qlik.com/t5/QlikView/Time-Format/m-p/745720#M1030347 Anonymous 2015-02-18T18:19:32Z Re: Time Format https://community.qlik.com/t5/QlikView/Time-Format/m-p/745721#M1030348 <HTML><HEAD></HEAD><BODY><P>Thanks Bill for your quick help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Wed, 18 Feb 2015 18:25:25 GMT https://community.qlik.com/t5/QlikView/Time-Format/m-p/745721#M1030348 vikasgupta 2015-02-18T18:25:25Z