Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.