SAP Knowledge Base Article - Public

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

Symptom

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

Environment

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

Cause

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)

Resolution

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

Keywords

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

Product

SAP Business ByDesign all versions