Exporting hours worked and work data proposals

The following information can now be downloaded in the export module:  

Sum of approved working hours: 

Total hours worked and approved in Work Data can now be exported as a sum. For this export, it is of no consequence whether the wage type is fixed or hourly.  

To export the total work time per assignment in hours, select the “Assignments” tab in the export module:  

Then go to “Resource Mapping”:  

After selecting the field “Assignment work times” and clicking on “fields”, a selection of exportable data opens. You can now choose any information on work times that you need. Once everything you need is selected, close the pop-up in the top righthand corner. 

Every field you select makes up one column in the export.  

"Work time excluding breaks" outputs the net working time in the export, i.e. the hours actually released with the break already deducted. "Work time including breaks" outputs the gross working time in the export, i.e. the total attendance, without taking the break time into account.

To achieve a meaningful export, you should set up some search criteria.  This can be, for example, the project name, or the time period in which the assignments took place. 

Depending on whether “user-friendly” or “machine readable” is selected, the entirety of all hours worked, as well as break times are exported either as hours and minutes, or as a number.  

To be able to use this list in Excel, we recommend choosing “machine readable”:  

Displaying work data proposals:  

Work data which has been proposed by staff members can now also be exported.  

As shown above, in “Edit resource map”, go to “Assignment work times”, then to the available fields. You can select the work data proposals here as well: