Adding times from an Excel sheet

[Anonymous]

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

[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 · Accepted solution]

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: