Forum Discussion
Convert start and end timestamps into interval data
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?
1 Reply
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.
