nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get billable hours in JIRa export

Aditya_lnrg7l

is there a way of getting a report from JIRA, where I would have enough details to see tickets, time spent, billable, nonbillable, ticket type and further details?

When I export issues from JIRA, I get all the details about a ticket bit never get the actual billable hours.

when I export tempo worklog, I get billable hours and other details but never get the ticket details present in JIRA

I need a report which can get me both.

Accepted answers

Roberto Miasack_13nx52

Hi, @Aditya

Natively, the hours in the jira are logged without much detail.
In order to be able to divide the hours into billable and non-billable, I added a plugin for this:

https://marketplace.atlassian.com/apps/6572/tempo-timesheets-time-tracking-reports?hosting=cloud&tab=overview

You can learn how to create this directly from the third-party vendor documentation:

https://www.tempo.io/blog/2013/tempo-timesheets-tip-of-the-month-keeping-track-of-billable-vs-non-billable-time

Cheers!

All comments

Roberto Miasack_13nx52

Hi, @Aditya

Natively, the hours in the jira are logged without much detail.
In order to be able to divide the hours into billable and non-billable, I added a plugin for this:

https://marketplace.atlassian.com/apps/6572/tempo-timesheets-time-tracking-reports?hosting=cloud&tab=overview

You can learn how to create this directly from the third-party vendor documentation:

https://www.tempo.io/blog/2013/tempo-timesheets-tip-of-the-month-keeping-track-of-billable-vs-non-billable-time

Cheers!

Levente Szabo _Midori_

Better Excel Exporter for Jira Cloud integrates with Tempo and comes with a pre-built template for exporting your Tempo (or other) worklogs into native Excel reports.

Browse the export samples and see if they serve as an inspiration for your reporting needs!

(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)

Yuliia_Borivets__SaaSJet_

Hi @Aditya

Another solution you can check out is the Issue History add-on developed by my team.

Here you can arrange the columns and add fields (assignee, time spent) you need to the report. Also, you can filter by project, sprint, date range, etc. Export to CSV and Excel is available.

export issue history.png

Miron Ivano _Worklog360_

Hi @Aditya

If you need an alternative our team have also build a great addon that has a solution for your problem - Timescale.

With it you can create reports with time spent, billable, nonbillable, ticket type and much more. After which you can export it in EXCEL, CSV, PDF.

Here is an example of the export:

Screenshot 2022-03-25 at 16.50.50.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud