# Feature OP-16060 - "Spent time (date)" filter in work package modules to show the sum of time spent on a WP in a selected period

Project: OpenProject
Status: new
URL: https://community.openproject.org/work_packages/OP-16060

## Planning

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Target versions | Wish List |
| Sprint |  |
| Backlog bucket |  |
| Votes | 1 |
| List |  |
| Roadmap |  |
| Relevance |  |

## OPEN POINTS / FEEDBACK

_No work packages_

## Features and Chunks

_No work packages_

## Bugs and other work packages

_No work packages_

## Technical Details

| Attribute | Value |
| --- | --- |
| Module |  |
| Feature Flag |  |
| Requires doc change | No |
| Enterprise plan |  |

## Details

| Attribute | Value |
| --- | --- |
| Pull preview |  |
| Mockups |  |
| Accessibility | No |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Feature Lead |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Estimates and progress

| Attribute | Value |
| --- | --- |
| PD (min) |  |
| PD (max) |  |
| Work |  |
| Labor costs |  |

## Description

**As** a project manager  
**I want to** be able to create a status report (an Excel export) on a set of work packages including the spent time logged on set work packeges in a given period by filtering the Spent time of work packages in the work package module  
**so that** I can easily and swiftly create an Excel report that has Spent time data relvant only to the reporting period.&nbsp;

**Acceptance criteria**

*   There is a new filter crtiterion in the work package module that is called &quot;Spent time (date)&quot;.
    
*   This &quot;Spent time (date)&quot; filter works as &quot;Date (spent)&quot; in the &quot;Time and cost&quot; module, i.e. I can select the same time constraints (between dates, this week before/after etc.).
    
*   The work package view that has &quot;Spent time (date)&quot; filter shows only those work packages that have new spent time logged on them in the selected time constraint (i.e. WPs on which times were logged &quot;this week&quot;).
    
*   The column &quot;Spent time (date)&quot; shows the sum of the logged times in the selected time constraint.
    

Currently, there is no way to create such an Excel export. The main difference between an export to be made through &quot;Time and cost&quot; and the work package module as described above is that when I use &quot;Time and cost&quot; I am interested in the logs, activity etc., but when I want this kind of status report as stated above, I am only interested in the sum of times logged on each work package in the selected time period.
