Jira Expression to get worklog time during group of statuses

[Deleted user]

I need a Jira Expression that tells me how much time a user spent on specific grouping of statuses. i.e. If I want to get the time while in dev then I want the work hours spent between New and In Progress. Another would be while a status is in QA so if it QA Ready to QA Passed and any statuses in between.

I know that this is hard and was told that the best way to do this is with the logic of:

1. Loop through the changelog and get intervals (start and end timestamps) when the issue was in "X" status.
2. Loop through worklogs and sum up the timeSpent for worklogs that fall into those intervals.

Is anyone good enough with Expressions that can help.  And no I can't use Scriptrunner to do this.