Jun 18 2022 09:40 PM
I have this table
Equipment ID | Start Date (dd/mm/yyyy) | Start Time | End Date (dd/mm/yyy) | End Time | Work Type | Downtime |
LD1 | 05/06/2022 | 18:00:00 | 06/06/2022 | 6:00:00 | PM | 12.0 |
JB2 | 05/06/2022 | 18:00:00 | 06/06/2022 | 6:00:00 | PM | 12.0 |
JB2 | 04/03/2022 | 6:00:01 | 30/05/2022 | 6:00:00 | BD | 2,088.0 |
TR1 | 05/06/2022 | 6:00:00 | 05/06/2022 | 18:00:00 | PM | 12.0 |
GR2 | 20/05/2022 | 6:00:00 | 30/05/2022 | 6:00:00 | PM | 240.0 |
I want to be able to spread the downtime hours between days (each day is 24hrs) and how do i link it to a date table to do different filters.
I also have tables for Equipment ID and Work type
I have a Date table that i would like to link to this table so that i can filter by weeks, months, calendar days, fiscal periords
I am using power query
Jun 19 2022 10:09 AM
SolutionPower Query to generate daily downtimes could be as in attached file.
Jun 19 2022 01:29 PM - edited Jun 19 2022 07:11 PM
Hello Sergei
Thanks for you solution
Jul 12 2022 04:04 PM
Jul 13 2022 07:22 AM
What exactly doesn't work and which Excel version / platform do you use?
I added Power Query to your file, source is converted to structured table. Please check attached.
Jun 19 2022 10:09 AM
SolutionPower Query to generate daily downtimes could be as in attached file.