TAT and Queue Time - Production

[KrenzyRyan]

Here is a screenshot of the data and an end-state process map.

I want to somehow create a query that captures Queue time, TAT (turn around time), and Processing time with the given information in the table. If anyone can help get me started, that would help out a ton! I just don't know where to start!

Thanks everyone, this site is great.

[NTC]

well if your intervals are fixed as you display then its straightforward - in a query you set up calculated values. either add up from the starttime or subtract down from the finish time. ie.

AnalyticalFinish: DateAdd("h",1,[St Time])

Hope this helps.