Handling negative time in average calculations

[peterderrington]

Hi, 

I've got a quick question regarding how QlikView handles negative values for time.

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

It calculate the median average fine (displaying -00:06:00).

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

Can anyone help?

[sunny_talwar · Accepted solution]

Not entirely sure I understand, but seems like you need Interval() function instead of Time()

[peterderrington]

Perfect - that's exactly what it was - Thank you!