powerquery - PowerBI Working hours calculation without start end time

Question

I have this table with only start time of every task. What I want to do is to calculate for every user his starting time (doesn't matter what task) and end time (doesn't matter what task). Basically I want working hours for each day for each each user.

I tried to do this:

    enter work = MINX(
    SUMMARIZE(events,events[Date Only].[Date],events[user_id],
        "MINN",MIN(events[ConvertedTimeToInteger])
    ),
    [minn]
)

    exit work = MAXX(
    SUMMARIZE(events,events[Date Only].[Date],events[user_id],
        "MAXX",MAX(events[ConvertedTimeToInteger])
    ),
    [MAXX]
)

It works for a daily calculation, but for a total calculation its not good as it takes min/max of the date period:

Any help much appreciated

Answer 1

Ok, I have found a solution!

I had to summarize by 2 columns :

duration = SUMX(SUMMARIZE(events,events[date].[Date],events[user_id],"datesesese",DATEDIFf([Enter time],[exit time],HOUR)),[datesesese])

Solution