Average time in and time out in qlikview

[capriconuser]

This is the data i have . i want to get Avg time in and avg time out by year , month and week ... for this we may used attendaceday field (there are dates in this not days)

how i get avg time in and time out ?

https://www.dropbox.com/s/xaps82qyyo6i0fa/ar.xlsx?dl=0