SAP Knowledge Base Article - Public

2614214 - Billable Hours Appears Incorrect When you Export the Time Recordings From Activity List


Hours and billable hours appears incorrect when you export the time recordings under activity list for project


SAP Business ByDesign

Reproducing the Issue

  1. Go to the Project Management work center
  2. Go to the Projects view and select the relevant Project
  3. Select Activity List and select the Period Selection (Date From / To)
  4. Select Go under the Time Recordings section
  5. You can see the Hours and Billable Hours are correct
  6. Select Export To Microsoft Excel®
  7. In the export excel, you will see the incorrect hours


The export data depends on the time format which you have selected in your personalization settings. If you have set the time format to 12 hrs., then you
will see the converted value in the hour's column of the exported excel

For Example:

You have 14 hrs entered in the time sheet and the same will appear in the Time Recordings section under Activity List. You have time format defined for 12 hrs. When you export the list, system will calculate the hours as below;

14 hrs. (Employee time) - 12 hrs. (Time format) = 2 hrs. (Display hours in the export excel)


You must change the time format to 24 hrs. and then system will show the complete hours in the exported excel


Export time recordings to excel from activity list, Export time recordings , KBA , export time recordings to excel , export activity list data to excel , AP-PRO-PRJ , Project , Problem


SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1711 ; SAP Business ByDesign 1802 ; SAP Business ByDesign 1805