https://community.qlik.com/t5/QlikView/Handling-negative-time-in-average-calculations/m-p/1645505#M731198 <P>Not entirely sure I understand, but seems like you need Interval() function instead of Time()</P> Mon, 11 Nov 2019 16:55:46 GMT sunny_talwar 2019-11-11T16:55:46Z https://community.qlik.com/t5/QlikView/Handling-negative-time-in-average-calculations/m-p/1645466#M731197 <P>Hi,&nbsp;</P><P>I've got a quick question regarding how QlikView handles negative values for time.</P><P>I've got a straight table and if i ask it to simply average the time there is a late or early finish (early finishes display a negative time whilst late finishes show a positive time) it shows the time as 23:38:38 where as its actually -00:21:21</P><P>It calculate the median average fine (displaying -00:06:00).</P><P>In the Number formatting section I picked 'Time' for the average whilst for the median i just left it as Expression Default, however if i pick Expression Default for average then it shows it as a -014830247 which is the decimal version of the correct -00:21:21</P><P>Can anyone help?</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Handling-negative-time-in-average-calculations/m-p/1645466#M731197 peterderrington 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Handling-negative-time-in-average-calculations/m-p/1645505#M731198 <P>Not entirely sure I understand, but seems like you need Interval() function instead of Time()</P> Mon, 11 Nov 2019 16:55:46 GMT https://community.qlik.com/t5/QlikView/Handling-negative-time-in-average-calculations/m-p/1645505#M731198 sunny_talwar 2019-11-11T16:55:46Z https://community.qlik.com/t5/QlikView/Handling-negative-time-in-average-calculations/m-p/1645507#M731199 <P>Perfect - that's exactly what it was - Thank you!</P> Mon, 11 Nov 2019 16:57:57 GMT https://community.qlik.com/t5/QlikView/Handling-negative-time-in-average-calculations/m-p/1645507#M731199 peterderrington 2019-11-11T16:57:57Z