Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Adding times from an Excel sheet

Hi

I have a list of times importing from an Excel sheet.

LOGGED_IN_DURATION

06:52:42

00:54:16

05:45:09

02:11:45

07:49:21

08:00:02

Formatted in custom (hh:mm:ss)

If I add the field to a statistics box and sum I get the answer 07:33:15 (format overriden to TIME)

How is this so? If I filter out the last time of 08:00:02 it does add up correctly. but including this does skew the results.

Many thanks in advance

1 Solution

Accepted Solutions
marcus_sommer

Your sum of hours is greater then 24 hours - you need to divide your result / 24 hours to get in days or you used interval() which give you as result 31 h ...

- Marcus

View solution in original post

3 Replies
sunny_talwar

Not sure what you are getting and what you intend to get. You want to see a different sum or format in the statistic box object??

marcus_sommer

Your sum of hours is greater then 24 hours - you need to divide your result / 24 hours to get in days or you used interval() which give you as result 31 h ...

- Marcus

sunny_talwar

See if this is what you want:

Capture.PNG