calculating cycle time out of timestamps

[youneskil]

Hi guys!

I have got an assambly line where the product is transported by a driverless transport system (DTS). The line consists of 27 cycles.

Whenever a DTS enters a manufacturing cycle a timestamp is generated by a SPS. The target time for each cyle is 90 sec. Beside a timestamp the SPS writes a task number, a date, a cycle name and a DTS ID.

I imported the data into Power Bi.

My goal is to analyse the real cycle time for each product or DTS.

I tried to sort the data according to time or cycle name and then subtract the successors timestamp from the predecessors timestamp, but that doesn´t make sense.



What would you recommend?

 

[etaf]

can you provide a sample of your data, expected results and why - would help see if we can produce a function

i'm assuming you want to see any duration thats over 90secs between an ID , but not sure what your titles represent