Problem with summing time periods over 10 hours!

[snehamahaveer]

    Hi ,

I am calculating the total time spent for a particular activity by adding all the activity times over a period of a month.

The values are correct if the total is below 10 hours, how do I make sure that the addition of activity time period is correct for bigger values.?

I use, = sum(time(endtime-starttime, 'hh:mm')) to calculate. Also is it possible to divide the time by another time?

eg. = sum(time(endtime-starttime, 'hh:mm')) / Working_hours

Thanks in advance

[snehamahaveer]

Hi,

On close inspection I find that only OPD values are proving to be troublesome.

Are there any comments for troubleshooting?

[sasiparupudi1]

post those timestamps in the excel document

[snehamahaveer]

There are thousands of lines of such data. It would be useless trying to do that!

[snehamahaveer]

Actually Sasidhar, all values that sum up over 10 have the issue, but in one instance I found OPD value giving wrong value even though the value was supposed to be 05:00 hours.

I am sorry for the confusion.

[snehamahaveer]

Krishna

It seems to be working on your test, but on my qvw it is playing up.

[krishna20]

Hi Sneha,

I tested with the sample data which you provided only.Try with changing the expressions.

[MarcoWedel]

Hi,

one solution could be:

=Interval(Sum(ENDDATE-[Start date and time]),'hh:mm')

hope this helps

regards

Marco

[snehamahaveer]

HI Everyone,

Thank you so much for your suggestions, I have learnt time representation in Qlikview.

It so happens, my primary key for the table was associated with another table which had multiple values for the same value. Hence the data was summed up and represented as 'Days and Time'. Using the distinct and aggregate I was able to resolve the issue.

Thanks once again.