Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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??
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
See if this is what you want: