https://community.qlik.com/t5/App-Development/Converting-integer-field-to-minutes/m-p/1896042#M73925 <P>You can sum integers for minutes and you should get a correct result ,assuming 116 is 116 minute rather than 1 hour, 16 minutes. If the latter is true, you would need to break it up, which I think should be:</P> <P>Mod(100,YourField)&nbsp; //= minutes part</P> <P>+</P> <P>Div(100,YourField)*60 //= hours part</P> Tue, 22 Feb 2022 15:29:00 GMT Or 2022-02-22T15:29:00Z https://community.qlik.com/t5/App-Development/Converting-integer-field-to-minutes/m-p/1896033#M73923 <P>Hi all,&nbsp;</P> <P>I need some help regarding how to convert numeric/integer field into minutes. The field in question already contains the minutes in the following format - 2.00 (2 minutes), 3.00, 10.00, 116.00 etc...<BR /><BR />When I want to do a sum to this field, I get very weird numbers, so I believe I need to convert it to minutes first.</P> <P>Any ideas?&nbsp;</P> <P>Thanks!</P> Tue, 22 Feb 2022 15:20:11 GMT https://community.qlik.com/t5/App-Development/Converting-integer-field-to-minutes/m-p/1896033#M73923 ShellyG 2022-02-22T15:20:11Z https://community.qlik.com/t5/App-Development/Converting-integer-field-to-minutes/m-p/1896042#M73925 <P>You can sum integers for minutes and you should get a correct result ,assuming 116 is 116 minute rather than 1 hour, 16 minutes. If the latter is true, you would need to break it up, which I think should be:</P> <P>Mod(100,YourField)&nbsp; //= minutes part</P> <P>+</P> <P>Div(100,YourField)*60 //= hours part</P> Tue, 22 Feb 2022 15:29:00 GMT https://community.qlik.com/t5/App-Development/Converting-integer-field-to-minutes/m-p/1896042#M73925 Or 2022-02-22T15:29:00Z