topic Re: Time Addition in QlikView https://community.qlik.com/t5/QlikView/Time-Addition/m-p/359740#M133562 <HTML><HEAD></HEAD><BODY><P>it is base 60</P></BODY></HTML> Tue, 19 Jun 2012 18:58:21 GMT 2012-06-19T18:58:21Z Time Addition https://community.qlik.com/t5/QlikView/Time-Addition/m-p/359738#M133560 <HTML><HEAD></HEAD><BODY><P>i have column time spends values like 0:3:12,0:2:12,0:2:20,0:4:18 and it is in mili second.</P><P>i want to add this time value and want to show A:B.</P><P>how i can achive this.</P></BODY></HTML> Tue, 19 Jun 2012 18:21:08 GMT https://community.qlik.com/t5/QlikView/Time-Addition/m-p/359738#M133560 2012-06-19T18:21:08Z Re: Time Addition https://community.qlik.com/t5/QlikView/Time-Addition/m-p/359739#M133561 <HTML><HEAD></HEAD><BODY><P>This format gives the time in milliseconds? Could you define the format a bit closer?</P><P> I can tell three different parts separated by ':', so the most left part is giving milliseconds? The next two are giving what? Is the number base per part 60 or 100?</P><P></P><P>If it's more of a commonly used time format, like hh:mm:ss, you could parse these in as time or interval values and just add them using</P><P>=interval( sum( FIELD) )</P></BODY></HTML> Tue, 19 Jun 2012 18:53:02 GMT https://community.qlik.com/t5/QlikView/Time-Addition/m-p/359739#M133561 swuehl 2012-06-19T18:53:02Z Re: Time Addition https://community.qlik.com/t5/QlikView/Time-Addition/m-p/359740#M133562 <HTML><HEAD></HEAD><BODY><P>it is base 60</P></BODY></HTML> Tue, 19 Jun 2012 18:58:21 GMT https://community.qlik.com/t5/QlikView/Time-Addition/m-p/359740#M133562 2012-06-19T18:58:21Z