Accepts the CSV file from Jira's “Export Excel CSV (all fields)”.
In Jira: Issues → search with a JQL filter for the worklogs you need, then Export → Export Excel CSV (all fields).
Worklog Report
Sample data — drop your Jira export above to use your own
This is a sample
Invented worklogs, run through the real calculation. Change the rules and the numbers respond exactly as they would with your own export. Drop a CSV file above to replace it with your own.