Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

sum time

hi,

i calculte time at the script  like this =  endtime-starttime

the result per line is O.K.

at pivot table i try to sum this feild and the result are wrong.

when i use interval formt number when the times are in a differnt days the result is also wrong.

exm:

starttime - 01/02/16  23:38

endtime - 02/02/16   00:19

i get 41

in summeries the result is wrong when the sum is over 24h

in interval i get -23:19

how can i sum this feild good ?

thanks'

yarin.

1 Reply
Anonymous
Not applicable
Author

hi,

please go through following

Time Difference or Time in Human Readable Format