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; } } }

Como calcular el tiempo trabajado en un periodo de tiempo definido

Fabián Actis

Necesito sumar el tiempo trabajado en una actividad pero solo de aquellos registros de trabajo que estén dentro de un rango de fechas determinado.

Esto es para calcular, por ejemplo, el tiempo trabajado en un mes determinado para cada actividad, pero solo sumando aquellos registros de trabajo que se hayan registrado dentro del mes en cuestión.

Por ejemplo, tengo la actividad 1 que tiene cuatro registros de trabajo:
01/05/2026 - 2 hs.
15/06/2026 - 1 hs.
18/06/2026 - 3 hs.
02/07/2026 - 1 hs.

Quiero sumar solo las horas trabajadas en Junio, por lo cual el resultado debería ser: 4 hs.

Cómo puedo hacer?

Accepted answers

Varun Chillamcharla

Hi Fabián,

You can filter issues that have worklogs in a date range using JQL's worklogDate() function, like:

worklogDate >= "2026/06/01" AND worklogDate <= "2026/06/30"

The catch is this only shows you issues that had a worklog in that range — it doesn't sum just those hours. The time logged field on the issue adds up ALL logged time, including entries outside the range you're filtering on.

For actually summing hours within a specific date range, Jira doesn't handle that well natively. Your best options are:

1. Tempo Timesheets (Marketplace app) — built exactly for this, with reports by date range and by activity/issue (currently using this myself).
2. REST API — pull each issue's worklogs and filter/sum by date yourself in a script.

If it's a one-off need, exporting worklogs via the API and summing them in Excel is also a quick option without needing an app

Matteo Vecchiato

Hola @Fabián Actis ,

Como indica @Varun Chillamcharla , la reporstica de base de Jira relacionado con los registros de trabajo es bastante basica.

Puedes ver los report nativos en esta pagina: https://confluence.atlassian.com/jirakb/reporting-in-jira-461504615.html

Si las funciones estandard para registrar los tiempos de trabajo es suficiente, y solo necesita reports más potentes, aconsejo evaluar:

- https://marketplace.atlassian.com/apps/1220925/custom-charts-for-jira-reports-dashboards-graphs-tables?hosting=cloud&tab=pricing

- Para reportistica avanzada: https://marketplace.atlassian.com/apps/1211051/eazybi-for-jira-reports-charts-and-dashboards?hosting=cloud&tab=overview

Espero que sea de ayuda

Danut M _StonikByte_

Hi @Fabián Actis,

Jira does not offer many options for this type of calculation. You could try using the Time Tracking Report available in the Reports section of your project/space. Eventually export that data in Excel and apply manual calculations.

An easy alternative is to search the Atlassian Marketplace for an app that provides this type of report or dashboard gadget.

Are you using Jira Cloud or Data Center?

If you're willing to try an app and have Jira Cloud, the Advanced Edition of our Great Gadgets app offers a Worklog Reports & Timesheets Gadget that does exactly what you need.

To get a report like this, all you have to do is add this gadget to a Jira dashboard and configure it like this:

Alternatively you can use the same gadget in Confluence Cloud. The gadget is localized in Spanish.

Hope this helps.

Danut.

All comments

Varun Chillamcharla

Hi Fabián,

You can filter issues that have worklogs in a date range using JQL's worklogDate() function, like:

worklogDate >= "2026/06/01" AND worklogDate <= "2026/06/30"

For actually summing hours within a specific date range, Jira doesn't handle that well natively. Your best options are:

If it's a one-off need, exporting worklogs via the API and summing them in Excel is also a quick option without needing an app

Matteo Vecchiato

Hola @Fabián Actis ,

Como indica @Varun Chillamcharla , la reporstica de base de Jira relacionado con los registros de trabajo es bastante basica.

Puedes ver los report nativos en esta pagina: https://confluence.atlassian.com/jirakb/reporting-in-jira-461504615.html

Si las funciones estandard para registrar los tiempos de trabajo es suficiente, y solo necesita reports más potentes, aconsejo evaluar:

- https://marketplace.atlassian.com/apps/1220925/custom-charts-for-jira-reports-dashboards-graphs-tables?hosting=cloud&tab=pricing

- Para reportistica avanzada: https://marketplace.atlassian.com/apps/1211051/eazybi-for-jira-reports-charts-and-dashboards?hosting=cloud&tab=overview

Espero que sea de ayuda

Varun Chillamcharla

Thanks, Matthew — good additions. Custom Charts and eazyBI are solid alternatives too, especially if Fabián needs more flexible dashboard-style reporting beyond timesheets specifically

Fabián Actis

Hi Varun, hanks for the clarifications and suggestions on how to resolve this; I’ll look them over to decide how to proceed.

Varun Chillamcharla

You're welcome, Fabián — good luck with it, and feel free to follow up if you run into anything specific while setting it up.

Fabián Actis

Hola Matteo, gracias por tomarte el tiempo para responder, veré como seguir en base a sus comentarios.
Saludos y gracias!!

Danut M _StonikByte_

Hi @Fabián Actis,

An easy alternative is to search the Atlassian Marketplace for an app that provides this type of report or dashboard gadget.

Are you using Jira Cloud or Data Center?

If you're willing to try an app and have Jira Cloud, the Advanced Edition of our Great Gadgets app offers a Worklog Reports & Timesheets Gadget that does exactly what you need.

To get a report like this, all you have to do is add this gadget to a Jira dashboard and configure it like this:

Alternatively you can use the same gadget in Confluence Cloud. The gadget is localized in Spanish.

Hope this helps.

Danut.

Fabián Actis

Hola Danut, aprecio mucho tu respuesta y las sugerencias sobre el tema, realmente me ha servido para obtener la información que necesito.
Saludos y gracias nuevamente.