Frequently Asked Questions

How can I log time in Jira?

You can log time in Jira from the Time Tracking section of any issue. Check How to use Jira Time Tracking for more detailed instructions on logging time.

 

How can I use Timesheet Export?

Once installed, Timesheet Export is available from the Project menu in Jira, as well as the Reports page. Check Using Timesheet Export for Jira for more detailed instructions on using Timesheet Export.

 

Does Timesheet Export include time spent in hours in exports?

Yes. In addition to having time spent in Jira’s format (eg. 1d 2h 30m) and time spent in seconds, Timesheet Export also includes the time spent in hours in every export of tracked time. For example, 2.5 will be used to represent 2 hours and 30 minutes.

See below for a full list of fields included in exports from Timesheet Export.

 

Which fields can be exported for time tracked in Jira projects?

Fields exported by Timesheet Export:

  • Project: Name of the project exported from.
  • Issue Type: Type of issue that time was logged against.
  • Issue Key: Issue key that time was logged against.
  • Priority: Priority of the issue that time was logged against.
  • Assignee: Name of the person assigned to the issue.
  • Status: Status of the issue that time was logged against.
  • Summary: Summary of the issue time was logged against.
  • Worklog Started Data: Date the worklog started on.
  • Worklog Started Time: Time the worklog started at.
  • Worklog Time Spent (hours): Time spent in the worklog in hours. (eg. 1.5 would indicate 1 hour and 30 minutes)
  • Worklog Comment: Comment about the logged work.
  • Author: Author of the worklog.
  • Worklog ID: ID of the worklog.
  • Worklog Time Spent: Time spent in the worklog in Jira’s format. (eg. 1d 3h 5m would indicate 1 day, 3 hours, and 5 minutes)
  • Worklog Time Spent (seconds): Time spent in the worklog in seconds.
  • Worklog Created Date: Date the worklog was created.
  • Worklog Created Time: Time the worklog was created.
  • Worklog Updated Date: Date the worklog was updated.
  • Worklog Updated Time: Time the worklog was updated.
  • Worklog Started: Date and time the worklog started at.
  • Worklog Created: Date and time the worklog was created.
  • Worklog Updated: Date and time the worklog was updated.
  • Assignee Email: Email of the person assigned to the issue.
  • Author Email: Email of the author of the worklog.
  • Worklog Updated: Time the worklog was last updated.
  • Project Key: Key of the project exported from.
  • Assignee Account ID: Account ID of the person assigned to the issue.
  • Author Account ID: Account ID of the author of the worklog.
  • Resolution: The resolution of the issue that time was logged against.

Additionally, there are some fields which can only be exported from Jira Software or Jira Service Desk.

Jira Software Fields

  • Epic Name: Name of the epic for the issue against which time was logged.
  • Epic Key: Key of the epic for the issue against which time was logged.
  • Story Points: Number of story points that the issue has.
  • Original Estimate (hours): Number of hours estimated for the issue, excluding sub-tasks.

Jira Service Desk Fields

  • Reporter: Name of the issue reporter.
  • Reporter Email: Email of the issue reporter.
  • Reporter Account ID: Account ID of the issue reporter.
  • Organizations: Name(s) of the organizations involved.
  • Request Type: The type of request that time was logged against.