Grouping issues

[gplhl]

Afternoon, I am trying to work out from a data set how long a particular type of work has been running. I have start and end times, and can create a key field, but my problem is the data is being produced over multiple years, 24 hours a day. So looking for how to group I am struggling. At the change of any item in Orange, I need to group by and subtract the min start time from max end time. However, this data is repeated several times within the table and crosses days, so I cannot add a date into a key. If there is a gap I need to count as separate. Trying to do this in powerquery.

 

[GlennUK]

Just add subtotals for change in Key - choose MAX for Start Time and End Time, then you need to change SUBTOTAL(4 to SUBTOTAL(5 for Start TIme - then collapse to level 2, and create your Run Time formulas in the visible cells.

 

[alansidman]

Reload your data using XL2BB so that we don't have to retype your data to test our solutions. This is possible in Power Query, but you need to give us data we can manipulate.