topic Re: How to Calculate Start Time -End Time for each Pallet ID in QlikView https://community.qlik.com/t5/QlikView/How-to-Calculate-Start-Time-End-Time-for-each-Pallet-ID/m-p/601201#M222424 <HTML><HEAD></HEAD><BODY><P>Thanks Gopal</P></BODY></HTML> Tue, 18 Feb 2014 15:24:14 GMT rustyfishbones 2014-02-18T15:24:14Z How to Calculate Start Time -End Time for each Pallet ID https://community.qlik.com/t5/QlikView/How-to-Calculate-Start-Time-End-Time-for-each-Pallet-ID/m-p/601199#M222422 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Please see the attached, I have a field called PalletNumber and I want to calculate how much time it took to pick the cases for each pallet ID</P></BODY></HTML> Tue, 18 Feb 2014 14:55:32 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-Start-Time-End-Time-for-each-Pallet-ID/m-p/601199#M222422 rustyfishbones 2014-02-18T14:55:32Z Re: How to Calculate Start Time -End Time for each Pallet ID https://community.qlik.com/t5/QlikView/How-to-Calculate-Start-Time-End-Time-for-each-Pallet-ID/m-p/601200#M222423 <HTML><HEAD></HEAD><BODY><P>Hello Alan,</P><P>Follow the steps below:</P><P>1. Add a straight table</P><P>2. Add PalleteNumber as dimension</P><P>3. Write the expression below:</P><P>minute(num(max([End Time]))-num(min([Start Time])))</P><P></P><P>This will give results in minutes</P><P>If you wish, you can create two expressions for Max([Time Period]) and Min([Time Period]) and then in third you just need to write column(2)-column(1)...</P><P></P><P>Hope this helps.</P></BODY></HTML> Tue, 18 Feb 2014 15:10:40 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-Start-Time-End-Time-for-each-Pallet-ID/m-p/601200#M222423 gopalopsharma 2014-02-18T15:10:40Z Re: How to Calculate Start Time -End Time for each Pallet ID https://community.qlik.com/t5/QlikView/How-to-Calculate-Start-Time-End-Time-for-each-Pallet-ID/m-p/601201#M222424 <HTML><HEAD></HEAD><BODY><P>Thanks Gopal</P></BODY></HTML> Tue, 18 Feb 2014 15:24:14 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-Start-Time-End-Time-for-each-Pallet-ID/m-p/601201#M222424 rustyfishbones 2014-02-18T15:24:14Z