Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a gadget that will allow you to calculate 'Time Spent' for multiple stories?

Levi Day
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 6, 2024

Is there a gadget that will allow you to calculate 'Time Spent' for multiple stories? For instance, if I have 7 stories and I have updated time spent on each story 1h15m, 3h30m, 45m, 25m, 2h, 1h, 30m.  => totaling 9h25m time spent.

2 answers

1 accepted

3 votes
Answer accepted
Ashish Bijlwan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 6, 2024

Hi @Levi Day 

Welcome to Atlassian Community!

You can use Workload Pie Chart gadget.

 

Thank you,
Ashish

Levi Day
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 6, 2024

Thank you! That is exactly what I am looking for.

 

Like Ashish Bijlwan likes this
Ashish Bijlwan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 6, 2024

Glad to hear that @Levi Day 

0 votes
Hannes Obweger - JXL for Jira
Atlassian Partner
December 8, 2024

Hi @Levi Day

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, you may also want to have a look at the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets.  It also comes with a long list of advanced features, including support for sum-ups. With sum-ups, you can build a view like e.g. this in just a couple of clicks:

time-spent-per-component.gif

As every JXL sheet is powered by a JQL statement or saved filter, you have full control over which issues you want to show and sum-up. (In addition to sum-ups, I'm using issue grouping here to calculate the time spent by component, but you probably don't even need that.)

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to conditional formatting, or bulk editing via copy/paste.

Any questions just let me know,

Best,

Hannes

Suggest an answer

Log in or Sign up to answer