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.

[Rilwan Ahmed · Accepted solution]

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?