Calculate time differences (multiple dates) in the same column filter by name in different column

[peifc75]

I hope someone can help. I have searched many places to hope for an answer.

I have this data, a column contains date and time. Another column has usernames. What I need to do is to count all of the same hour and date under the same user as equal to 1 hour. Example, below Ferdinand logged online on 1/1/23 with different minutes of the same hour at 3 pm will consider as 1 hour.

Anyone with a solution for this question I have, I truly appreciate. I have been wrecking my brain for awhile now.

Thank you in advance.

[peifc75 · Accepted solution]

Thank you so much for your help. This is what my boss is looking for.

[Ritaf1983]

Hi @peifc75 
You can split the column to date and time and use a dim timetable with the needed slots.
For more information, please refer to the linked video :
https://www.youtube.com/watch?v=-q7v56p192M&t=2s

or (less recommended solution) from PQ add column from example to the date time column :

Than you will get a column with a fixed date time to hours and use it as filter

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly