Exporting hours worked and work data proposals

Created by Carolina Mosing, Modified on Thu, 16 Feb, 2023 at 9:39 AM by Julia Kronister

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”:  

 

Ein Bild, das Text, Screenshot, drinnen enthält. 
Automatisch generierte Beschreibung 

 

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. 

 

Ein Bild, das Text, Screenshot, drinnen enthält. 
Automatisch generierte Beschreibung 

 

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.  

 

 

 

Ein Bild, das Text, Screenshot, drinnen enthält. 
Automatisch generierte Beschreibung 

 

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:  

 

 

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article