Convert start and end timestamps into interval data

[RobinvR]

Hello,

I'm struggeling with the following situation. Hopefully someone can help me out!

We have a dataset containing timestaps with start and end times on a specific status for each employee.

It looks like this (without employee names for obvious reasons)

We want to convert this data into sec per status in a specific timeframe (15 min intervals).

For example:

Interval start	Interval end	Status	Total time (sec)
08:45	09:00	Busy	2808
08:45	09:00	Offline	562
etc.	etc.	etc.	etc.

Can someone help out how we can achieve this?

[Anonymous]

Hi @RobinvR ,

You may try to create a table with time interval columns. More details you can refer to

How to generate date and time interval list using Power Query - Data Cornering

Then try to combine two table to filter the time columns.

Best Regards,

Stephen Tao

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