Average of time difference between two dates of 2 differents rows

[poluvidyasagar]

Hi All,

I am new to Qlikview.

I am trying to achieve this in Qlikview. Can any suggest me how to do it.

My Data Set:

Part	Event	Time
12345	StartTime	4/26/18 10:30 AM
12345	EndTime	4/26/18 12:30 PM
11111	StartTime	4/25/18 10:00 AM
11111	EndTime	4/25/18 11:00 AM
22222	StartTime	4/24/18 11:20 AM
22222	EndTime	4/24/18 12:20 PM

I would like to calculate the difference between start time and end time for each part and average it out. I want this happen in one expression.

In this case the result is (2 hours for first part+1 hour for second part + 1 hour for third part). so the average is 4/3

I have used Only({<Event={'EndTime'}>}Time)-Only({<Event={'StartTime'}>}Time) to get the difference. I am not sure how to calculate the average though.

Can someone help me with this?

Thanks,

[poluvidyasagar]

I would like to know for  both cases.

How to calculate if it is 8 hours a day and  24 hours a day?