topic Re: Count of time in QlikView https://community.qlik.com/t5/QlikView/Count-of-time/m-p/1065296#M925343 <HTML><HEAD></HEAD><BODY><P>How did 0:00:38 become 12:<STRONG>07:38 </STRONG>(07 is what concerns me). Can you share your application?</P></BODY></HTML> Wed, 06 Apr 2016 15:30:03 GMT sunny_talwar 2016-04-06T15:30:03Z Count of time https://community.qlik.com/t5/QlikView/Count-of-time/m-p/1065295#M925342 <HTML><HEAD></HEAD><BODY><P>Good day</P><P></P><P>I have time data that I want to count all the data that is less than 20 seconds</P><P></P><P>This is how the data looks like in Excel in the field</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 77px;"><TBODY><TR><TD align="right" class="xl63" height="19" width="77">0:00:38</TD></TR></TBODY></TABLE><P></P><P>but in the formula tab it look like this12:07:38 AM</P><P></P><P>How can I count</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Count-of-time/m-p/1065295#M925342 2020-11-25T16:16:04Z Re: Count of time https://community.qlik.com/t5/QlikView/Count-of-time/m-p/1065296#M925343 <HTML><HEAD></HEAD><BODY><P>How did 0:00:38 become 12:<STRONG>07:38 </STRONG>(07 is what concerns me). Can you share your application?</P></BODY></HTML> Wed, 06 Apr 2016 15:30:03 GMT https://community.qlik.com/t5/QlikView/Count-of-time/m-p/1065296#M925343 sunny_talwar 2016-04-06T15:30:03Z