topic Re: Time Calculation in QlikView https://community.qlik.com/t5/QlikView/Time-Calculation/m-p/1255049#M396707 <HTML><HEAD></HEAD><BODY><P>thank you - works perfectly.</P></BODY></HTML> Mon, 30 Jan 2017 12:46:45 GMT 2017-01-30T12:46:45Z Time Calculation https://community.qlik.com/t5/QlikView/Time-Calculation/m-p/1255047#M396705 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>During a data load I need to create a turnaround time from a dataset.&nbsp; In the example below, there is a distinct session id for a particular date.&nbsp; Within this session there are three units and by my calculation the average turnaround time for these three units is 49.5 mins.</P><P></P><P><IMG alt="turnaround_data.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/151200_turnaround_data.PNG" style="height: 56px; width: 620px;" /></P><P></P><P>Is it possible to create a field that calculates these turnaround times?</P><P></P><P>Many thanks for any help,</P></BODY></HTML> Mon, 30 Jan 2017 11:02:50 GMT https://community.qlik.com/t5/QlikView/Time-Calculation/m-p/1255047#M396705 2017-01-30T11:02:50Z Re: Time Calculation https://community.qlik.com/t5/QlikView/Time-Calculation/m-p/1255048#M396706 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>LOAD *,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(Session = Previous(Session), RangeSum([Time Started], -Previous([Time Finished]))) as [Turnaround Time]</STRONG></P><P><STRONG>Resident .....</STRONG></P><P><STRONG>Order By Session, [Time Started];</STRONG></P></BODY></HTML> Mon, 30 Jan 2017 11:16:38 GMT https://community.qlik.com/t5/QlikView/Time-Calculation/m-p/1255048#M396706 sunny_talwar 2017-01-30T11:16:38Z Re: Time Calculation https://community.qlik.com/t5/QlikView/Time-Calculation/m-p/1255049#M396707 <HTML><HEAD></HEAD><BODY><P>thank you - works perfectly.</P></BODY></HTML> Mon, 30 Jan 2017 12:46:45 GMT https://community.qlik.com/t5/QlikView/Time-Calculation/m-p/1255049#M396707 2017-01-30T12:46:45Z