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 calculate the total efforts since you have joined the JIRA Project

Meenu Antil

Hi,

I'm new to JIRA and just want to calculate the total time spent by any user in my team since they have joined the project. For ex- if I joined in March 2021 and I want to check my logged efforts since that time. So is there anything available in JIRA to extract such information in total.

I checked the gadget Time Sheet but there also I'm unable to find any option which can provide me this data (Total Logged Time) in just one go.

Please help me with this if possible.

Accepted answers

Rilwan Ahmed

Hi @Meenu Antil ,

Welcome to the community !!

I could not find any direct way to get the required data. But I have a work around.

Go to advanced search, and run below JQL.

worklogAuthor ="username required"

select column "Time Spent" in the display result and export to Excel(current fields)

In the excel, the time spent will be displayed as seconds. now convert it to minutes or hours as required for you.

All comments

Rilwan Ahmed

Hi @Meenu Antil ,

Welcome to the community !!

I could not find any direct way to get the required data. But I have a work around.

Go to advanced search, and run below JQL.

worklogAuthor ="username required"

select column "Time Spent" in the display result and export to Excel(current fields)

In the excel, the time spent will be displayed as seconds. now convert it to minutes or hours as required for you.

Meenu Antil

Thank you Rilwan, it worked for me.

Meenu Antil

Hi @Rilwan Ahmed

I'm back here again. I was trying to find one gadget which will show me the total time logged since I've joined the project but not luck. Also I would like to see the same for all team members. So is there any using which I can get this information at one place? On x-axis I need "Assignee" and on y-axis "Time Spent".

Could you please help in suggesting one suitable gadget for this?

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server