Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.

    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support

    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

General discussion
  1. OpenProject
  2. Forums
  3. General discussion
  4. Work package and spent time

Work package and spent time

Added by Ander Elexpuru over 10 years ago

Hi,

I need to export in a csv the subject, estimated time and the spent time, how can I do it? Can anybody help me?

Thanks


Replies (3)

RE: Work package and spent time - Added by Alexandru Matei over 10 years ago

Hi Ander

I don’t know if both the estimated time and the spent time (logged time) can be displayed together in the same place.

Doesn’t the Modules -> Cost reports help you ?

See the attached image

RE: Work package and spent time - Added by Ander Elexpuru over 10 years ago

Hi Alexandru,

Cost report does not help me, I need to add a column (spent time) in the workpackage queries, is these posible?

Thanks

RE: Work package and spent time - Added by Alexandru Matei over 10 years ago

The cost report allows you to calculate the spent time per project, per week, per user and other criteria etc.

Maybe somebody from the development team can give more info about how to display both the estimated time and the spent time.

Do you have SQL knowledge ? Maybe you can access directly the tables of the OpenProject MySQL database
find the tables and create your own .sql query.

  • (1 - 3/3)
Loading...