Skip to content
Menu
HelpMaking the totals match Jira’s time spent

Making the totals match Jira’s time spent

A Logline report and Jira’s Time spent field answer two different questions, so on the same work item they can show two different figures, and both can be right. This page shows where the difference comes from and how to account for every hour of it.

Two different questions

  • Jira’s Time spent on a work item is the total of every worklog on that work item, from any date, by anyone, including worklogs restricted to a group or role you are not in. It does not include the work item’s sub-tasks; Jira shows those added in as Σ Time Spent.
  • A Logline report adds up the worklogs that started on a day inside the report’s period, in the report’s time zone, by the people the report is limited to, that you are allowed to see. Each worklog counts once, on the work item it was logged on.

A worked example

Take one work item, ACME-7, with one sub-task, ACME-8. Jira shows Time spent 13h on ACME-7 and Σ Time Spent 16h, because ACME-8 has 3h of its own. A report on Last month (1 Sep to 30 Sep), every space, everyone, with rows by work item, viewed from Europe/Riga, shows 6h on ACME-7. Here is the 13h, worklog by worklog:

  • 4h logged in August. Outside the period, so not in the report. Add the extra column Logged (all time) to see Jira’s 13h beside the report’s 6h.
  • 1h started on 30 Sep at 23:30 in New York. In Riga that is 06:30 on 1 Oct, so with the viewer’s time zone it counts on 1 Oct, in October. With Each author’s time zone it would count on 30 Sep, in September. Every report names the time zone it counts in under its total.
  • 2h in a worklog restricted to a group you are not in. Logline reads as you, so it never sees that worklog. The report says so under its totals: “2h on 1 work item is in worklogs hidden from you”. A colleague in that group sees 8h on the same report.
  • 6h left, all started in September in Riga, visible to you: the report’s figure.

So 13h = 4h (August) + 1h (the period edge in Riga) + 2h (hidden from you) + 6h (the report). The sub-task’s 3h are not missing either: ACME-8 has its own row, and the work item panel on ACME-7 adds its children in.

Period edges and time zones

  • A worklog counts on the day it started, all of it, even if it runs past midnight.
  • The day is the report’s time zone: yours (from your Jira profile), each author’s own, or the one time zone a Jira admin set for everyone. Two people in different time zones can see a worklog near midnight on different days; pick Each author’s time zone in the report, or for the site in Settings, or set one time zone for everyone in Settings, to make everyone see the same days.
  • Rolling periods move with the calendar: Last month opened on 1 October and on 31 October is the same September; Last 30 days is not.

Worklogs hidden from you

Jira’s Time spent counts worklogs you may not see; Logline never does. Where Logline holds every worklog you may see on a work item (up to 20, which come with the work item), it names the difference under the report. A work item with more than that is read for the period only, so its hidden time, if any, is not in that line. See Permissions and data.

Sub-tasks and Σ Time Spent

A worklog on a sub-task is the sub-task’s, not its parent’s. Jira’s Time spent on the parent leaves it out and Σ Time Spent adds it in; a Logline report puts it on the sub-task’s own row. Group rows by Epic to see a whole epic’s time, sub-tasks included, in one row.

Deleted and moved work items

  • A worklog on a work item that has been deleted is gone from Jira: it is in neither Jira’s figures nor the report. An export taken before the deletion still has it, so an old file and a new report can differ.
  • A work item moved to another space counts under the space it is in now, in every period, including periods before the move.
  • A deleted worklog is gone from both the same way.

Reconciling a figure, step by step

  1. Open the report with the same period, scope and people as the figure you are checking, and set Rows to Work item on the line above the timesheet.
  2. Make sure Logged (all time) is picked under Columns, on the same line, to see Jira’s figure on each work item row next to the report’s.
  3. Read the small line under the total for the time zone the days are counted in (How this is counted spells out the rule), and the notes under it for time in worklogs hidden from you.
  4. For one work item, open its row with the arrow at its start, or the Worklogs view filtered by its key, to see every worklog the report counted, with its date, time and author.
  5. Anything still unexplained is a worklog outside the period: widen the period, or open the work item’s Work log tab in Jira.