Split up time spent evenly over number of checked options


I've added a checkbox custom field "billable" to assign the time spent to a certain option (customer). Sometimes an assignee will check more than 1 option when Time Spent needs to be evenly distributed over two or more customers.

When we export the data (using Time keeping tool) at the end of the month we can only get the total amount of Time Spent for each issue, and all checked options in a single cell (separated with commas).

Is there a way to split up the time spent over the amount of checked options in the custom field?

In a ideal world every checked option in the "billable" field would have its own line in the spreadsheet export, containing an even amount of time spent for each line. But I'll settle for any solution that allows me to split up the total amount of time :)

Thank you for your thoughts,


3 answers

Hi Tom, 

I think that the generic JIRA Timesheet report is not too adjustable, so there is not much room to change scope of the data exported. 

However if you have actually added custom field, why not use some JQL query in order to get the list or table with the time spent values and then export this JQL report to xls? This seem to me as a good option, the other more sophisticated is to use Tempo for much more detail tracking and reporting against time. 

0 votes

Create a calculated field for the Better Excel Plugin, that divides the timeSpent field's value among the customers. It does not look very difficult if you really need to just div it evenly.

Then create a custom template that utilizes this field.

For inspiration, see these examples.


Thanks for the feedback!

True,  the generic JIRA Timesheet report doesn't do much good :)
We use the "Time Reports and Gadgets for JIRA Cloud" add-on instead.

There doesn't seem to be a setting in the add-on that lets me split up time per chosen option in a custom field. So I just wondered if maybe we could use a different type of custom field to adjust the data in the excel export. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,653 views 18 21
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you